Date Filter Expression

[pvara]

I have a dataset that has historical data.

How can I modify this expression to include the previous calendar year?

[CREATEDATE] >= ToDate(DateTimeAdd(DateTimeToday(), -1, "year"))

The desired result would include CREATEDATE that has values From

2019-01-01 Thru 2020-11-04

Thank you

[MarqueeCrew]

How about:

[CREATEDATE] >= Left(DateTimeAdd(DateTimeStart(), -1, "year"),10)

 cheers,

 mark

[christine_assaad · Accepted solution]

Hi @pvara 

Is this what you are looking for?

[CREATEDATE] >= datetimeformat(ToDate(DateTimeAdd(DateTimeToday(),-1, "year")),"%Y-01-01")

Cheers!

[pvara]

Thank you christine your expression was spot on.. 

[Maskell_Rascal]

Hi @pvara 

This formula would also work for you. 

[CREATEDATE] >= Left(DateTimeAdd(DateTimeToday(), -1, "year"),4)

Thanks!

Phil