Date filter

[munchkin100]

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

[munchkin100 · Accepted solution]

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.