Date Greater than one year ago in setanalysis

[tinkerz1]

Hi,

I am trying to count all the reference numbers in a set for the previous year from Todays date.

count({1<MonthLogged={">=$(DATE(Today()-365,'DD/MM/YYYY'))'"}>}ReferenceNumber)

I have formatted Today() into the same format and MonthLogged and expanded the formula.

What am I missing to make this work?

Thanks

Neil.

[tinkerz1]

Its showing the whole date range of the data

[sunny_talwar]

I see nothing wrong with your expression. Would you be able to share a sample?

[tinkerz1]

I am afraid I cant sent a sample, however this worked when changing the date to a number in the script.

Count({<NumMonthLogged={">=$(=num(Today())-365)"}>}ReferenceNumber)

But I cant explain why dates wont work