Formula for date time

[Hi2023]

I am needing to retrieve the previous one month data from this column CRG_STAT every time report is run.

is this correct?  I am using SQL Editor in Alteryx

DateTimeFormat(CRG_STAT) >= DateTimeFormat(DateTimeAdd(DateTimeNow(), -1, "month"))

[Luke_C]

Hi @Hi2023 

Is this a duplicate post or different issue than your other topic? https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/previous-month-daate/td-p/1126...