Date Set Analysis & Variables

[#1]

Hi,

I'm simply trying to create a variable that counts the number of ID's for 'Yesterday' :

     count({<Date={'date(Today()-1)'}>}ID)

But this expression doesn't appear to be working....

The 'Date' field within my Dataset is in DD/MM/YYYY format if it helps.

Any help appreciated!

Tom

[Gysbert_Wassenaar]

Try count({<Date={"$(=date(Today()-1,'DD/MM/YYYY'))"}>}ID)

[Anonymous]

Hi!

Try this:

=count (distinct{<Your_date_field={"$(=date(Today()-1,'DD/MM/YYYY'))"}>} ID)

Hope it helps.

Gabriel

[ecolomer]

Try this:

COUNT({<Date={"$(=date(Today()-1))"}>}ID)