Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try count({<Date={"$(=date(Today()-1,'DD/MM/YYYY'))"}>}ID)
Hi!
Try this:
=count (distinct{<Your_date_field={"$(=date(Today()-1,'DD/MM/YYYY'))"}>} ID)
Hope it helps.
Gabriel
Try this:
COUNT({<Date={"$(=date(Today()-1))"}>}ID)