Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to get a count of surveys where the eventdate is before today.
eventdate is in the format DD/MM/YYYY if that makes a difference, this is the same format set as the date format at the start of the load script. It returns a count of -
count({<[visitreason2]={"*Survey*"} [eventdate] = {"<=$(=Today())"}} [$_serviceid])
Your expression looks OK with one exception, you are missing a comma between the modifiers. Try this expression:
count({<[visitreason2]={"*Survey*"} , [eventdate] = {"<=$(=Today())"}} [$_serviceid])