Date format change in set analysis

[jacek_stypulkow]

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 

[Gabbar · Accepted solution]

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)

[jacek_stypulkow]

Brilliant work!