Help needed in building a formula for MTD with today() function

[fashid]

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

[fashid]

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

[fashid]

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