Condition to calculate Month to date.

[berryandcherry6]

Hi all,

I want to calculate count of signups of Month to Date.What is the condition i could put for calculating Month To Date.

ex:  Count({$<client_id=12>}signups)

Please help me .

Regards,

Supriya

[miguelbraga]

Hey there,

I think that what you are looking for is something like this:

Count({$< client_id=12, Month={"$(=max(Month))"} >} signups)

Regards,

MB

[arulsettu]

may be this

count({< Datefield={">=$(=Num(MonthStart(Max(Datefield))))<=$(=Max(Datefield))"},client_id={'12'}>} signups)

[sunny_talwar · Accepted solution]

May be this:

Count({$<client_id= {12}, Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}>}signups)