Help with Set Analysis using Today()

[#1]

Hi

Can anyone please tell me what I'm doing wrong here

All I want to do is create a bar chart for today's open calls by category.

This works fine:

Count({1<ARRIVAL_DATE={'08/05/2014'},AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Then I want to add Today() so that if the report hasn't been refreshed nothing shows, but I can't seem to get the syntax right:

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'YYYY-MM-DD'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Many thanks

Paul

[tresesco · Accepted solution]

try:

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Be careful of the date format.

[#3]

Sure I'd tried that many times, and that I'd just introduced it by error when cutting and pasting from a previous post, but it now works.  Many thanks

[its_anandrjs]

Try with

You date format is not matched  it is 'DD/MM/YYYY'

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

[jagan]

Hi Paul,

Date format is the issue in Expression try this expression, you are formatting Today() to this 'YYYY-MM-DD' format but your date is in 'DD/MM/YYYY' format. 

=Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Regards,

jagan.