Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating MTD YTD values using the below expression
=Count({<CalendarDate={">=$(=(MonthStart(today()))<=$(=(today())))"}>}DISTINCT ENQUIRY_ID)
but i am getting zero result.
I need to use today function only as i have inconsistent dates in the application.
Could anybody help me out in this
Regards,
Nadeem
Hi Max,
Thanks for replying
i had to use
=Count({< DateNum={">=$(=Num(MonthStart(today())))<=$(=today()))"}>}DISTINCT ENQUIRY_ID).
I did not understand why the field with the dates did not work and why i had to deliberately convert it to num.
Regards,
Nadeem
Hi Ankita,
I am marking your answer as correct for the clear explanation that you gave
"Use the same dateformat as of your CalendarDate"
but thanks everybody for their contribution
Regards,
Nadem