Date field comparision

[bviswana]

I have a date field with MM/DD/YYYY format. I am trying this command and is not getting expected result

if (Year([END_DATE.autoCalendar.Year]) < Year('2019'),Count(NUMBER))

Basiccally, I need the count of NUMBER where the end date(year)  is < 2019 

Appreciate any help 

[sunny_talwar · Accepted solution]

How about this may be

If(Year([END_DATE.autoCalendar.Year]) < 2019, Count(NUMBER))

or this

Count(If(Year([END_DATE.autoCalendar.Year]) < 2019, NUMBER))

[bviswana · Accepted solution]

Count(If(Year([END_DATE.autoCalendar.Year]) < 2019, NUMBER)) - works. Thank You for the support