Expression Help!

[jameswills]

HI All,

I'm after some help with what I'm sure is a simple expression. Still can't get a handle on the syntax layout

I have a date field (DD/MM/YYYY) and a select in field button which identifies dates prior to today i.e. Overdue. The working button syntax is '='<' & Date(Today(),'DD/MM/YYYY').

What I'd now like to do is visualise a count of these overdue dates by another dimension (DIVISION). I've created a bar chart with DIVISION as the dimension so am looking for help in creating the expression syntax to calculate a count of dates prior to Today() please?

[Anil_Babu_Samineni · Accepted solution]

May be this?

Count({<datefield = {"<$(=Date(Today(),'DD/MM/YYYY'))"}>} datefield)

[Anil_Babu_Samineni]

When you say prior it should this?

Count({<datefield = {">=$(=Date(Today(),'DD/MM/YYYY'))"}>} datefield)

[jameswills]

Thanks Anil, both work great but it's the second expression which is returning what I need. Thanks for the reply