Set analysis help with less than

[jreimerink]

Hi All,

I'm struggling with the row below.

This shows all emails created today, but i want it to show before today.

I tried to add < but it only give back 0. Can somebody help me with this?

Thanks!

Count( {1<[Contact_Created.autoCalendar.Date] = { "$(=Date(Today(), 'D-M-YYYY'))" },Contact_Group={"TNL"},Contact_Channel={"Email"}>} [Contact_Created.autoCalendar.Date])

[MayilVahanan · Accepted solution]

Hi @jreimerink 

Try like below

Count( {1<[Contact_Created.autoCalendar.Date] = { "<$(=Date(Today(), 'D-M-YYYY'))" },Contact_Group={"TNL"},Contact_Channel={"Email"}>} [Contact_Created.autoCalendar.Date])

if its not working, please send the sample file

[jreimerink]

Thanks, this works!