Count if

[Anonymous]

Hi,

How can i use the count aggregation function of a date field (dd/mm/yyyy) when the field value is from the last 6 months/half a year?

meaning: count this field when its value is from the last 6 months.

for instance, the date field name is [initial insert date].

Thanks!

Tal

[Gysbert_Wassenaar]

Perhaps like this: count({<[initial insert date]={"=[initial insert date]>$(=AddMonths(Max([initial insert date]),-6))"}>} [initial insert date])

[jagan]

Hi,

Try like this

=Count({<[initial insert date] = {'>=$(=AddMonths(Today(), -6))<=$(=Today())'} [initial insert date])

You can find similar type of expressions from the link below

Set Analysis for Rolling Periods

Set Analysis for certain Point in Time

Hope this helps you.

Regards,

Jagan.

[Anonymous · Accepted solution]

Hi

the right answer is:

Count({<[initial insert date]={">=$(=Date(AddMonths(Today(),-6),'MM/DD/YYYY'))"}>} [initial insert date])

thanks!