Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
the right answer is:
Count({<[initial insert date]={">=$(=Date(AddMonths(Today(),-6),'MM/DD/YYYY'))"}>} [initial insert date])
thanks!
Perhaps like this: count({<[initial insert date]={"=[initial insert date]>$(=AddMonths(Max([initial insert date]),-6))"}>} [initial insert date])
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.
Hi
the right answer is:
Count({<[initial insert date]={">=$(=Date(AddMonths(Today(),-6),'MM/DD/YYYY'))"}>} [initial insert date])
thanks!