Date filter

Hi, I looked through the posts on forum, but none of the solutions work for me. I was wondering, if is there any smart way of filtering the data to the current year only, based on the date field (yyyy-MM-dd). I have tried to use

[Date]=DateTimeAdd(DateTimeToday(),-0,"years")

but it didnt work.

Most of the answers refer to a string format. Do I need to convert it to the string first? I would appreciate any help

Date Time

Accepted answers

munchkin100

Just solved it. I used this formula and it works perfect

[Date] >=
(DATETIMEFORMAT(DateTimeNow(), "%Y"))+"-01-01"
AND
[Date] <=
(DATETIMEFORMAT(DateTimeNow(), "%Y"))+"-12-31"

All comments

munchkin100

Just solved it. I used this formula and it works perfect

[Date] >=
(DATETIMEFORMAT(DateTimeNow(), "%Y"))+"-01-01"
AND
[Date] <=
(DATETIMEFORMAT(DateTimeNow(), "%Y"))+"-12-31"

atcodedog05

Hi @munchkin100

You can do

DATETIMEFORMAT([Date], "%Y")=DATETIMEFORMAT(DateTimeNow(), "%Y")

To check only for the current year.

Hope this helps : )

messi007

@munchkin100,

You can use DateTimeYear function as well.

Hope this helps.

Regards.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280