Comparing Date in Set Analyis

[neerajthakur]

Please help me with this.

count({<current_license_flag={'1'},status_id={'8'},[Expiry Date]={">=$(=vToday()"}>}distinct ref_id)

vToday is Num(Today())

Expiry Date is in timestamp format. How can I compare both date.

[rubenmarin]

Hi, there is no need to use () is the valriable, just in the today() function.

You can try with 

- [Expiry Date]={">=$(vToday)"}

- [Expiry Date]={">=$(=vToday)"}

- [Expiry Date]={">=$(=Timestamp(vToday))"}

- [Expiry Date]={">=$(=Timestamp($(=vToday)))"}