Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My date field format is set as the below
I would like to use the following expression to measure the items in previous month
Sum({<DateField
={'>=$(=AddMonths( MonthStart (Today()),-1))<=$(=AddMonths( MonthEnd (Today()),-1))'}>} Itemscounter).
It does not work due to date format. Can you advice how to correct date format settings or modify the expression.
Unfortunately the load script can not be changed in this case.
Regards
Jacek
try this:
Sum({<DateField
={">=$(=Date(AddMonths( MonthStart (Today()),-1),'YYYY-MM-DD hh:mm:ss.ffffff'))<=$(=Date(AddMonths( MonthEnd (Today()),-1),'YYYY-MM-DD hh:mm:ss.ffffff'))"}>} Itemscounter)
try this:
Sum({<DateField
={">=$(=Date(AddMonths( MonthStart (Today()),-1),'YYYY-MM-DD hh:mm:ss.ffffff'))<=$(=Date(AddMonths( MonthEnd (Today()),-1),'YYYY-MM-DD hh:mm:ss.ffffff'))"}>} Itemscounter)
Brilliant work!