Choose current year

[terrellchong]

Hi, I have a set of data that needs to filter out for current year.

I had inputted 

[Year]=ToNumber(DateTimeFormat(DateTimeToday(),"%yyyy"))

 into the filter but it doesn't seems to filter out 2020 (aka current year) for me. 

My data here [Year] are Int16 type.

Which part did I screw up?

[LordNeilLord · Accepted solution]

Hey @terrellchong 

Try this instead:

[Year]=ToNumber(DateTimeFormat(DateTimeToday(),"%Y"))

[terrellchong]

Thanks!! 😃

[hshandilya]

Modify the formula- The correct format for yyyy in Alteryx is %Y

[Year]=ToNumber(DateTimeFormat(DateTimeToday(),"%Y"))

 It is working perfectly fine for me.