Date Range in Set Analysis Expression

[#1]

I need help.

Problem -

I have a date field -

[Dealer Term Date]

My Expression =

count({<[Dealer Term Date] = {">={03/31/2016}"}>}[Student ID])

I am trying to get a count of [Student ID] where the [Dealer Term Date] is less than 03/31/2016.

I'm not getting any value. What am I doing wrong?

[miguelbraga]

Then make this little change:

count({<[Dealer Hire Date] = {"$(= '>=' & '01/01/2016' & '<=' & '03/31/2016')"}, [Dealer Term Date] = {"$(= '>=' & '01/01/2016' & '<=' & '03/31/2016')"}>} [Student ID])

This will make you what you want

Regards,

MB

[dhasharadh]

hi Sunny, I also have the similar situation where i need to show the counts for the previous year. 

I have tried using the same expression as above but its not working.

Count({< Date = {' >= 01.01.2021 <= 31.12.2021'}  >} Id)

it is showing expression 'ok' but still nothing comes in the line graph. 

Not only this I have tried few other as well. 

// Count({<  Date = {" > $(=YearStart(Date(Today(),'DD.MM.YYYY'),-1)) < $(=Yearend(Date(Today(),'DD.MM.YYYY'),-1)) "}  >}  Id)

// Count({< Date = {'>= 2021.01.01 <= 2021.31.12'} >} Id)

// Count({<  Date = {" $(= '>=' & '01.01.2021' & '<=' & '31.12.2021')" } >} Id)