RegexReplace help

[nataliad18]

Hi guys!
See screenshot attached. I can choose the second of given month, however I need it to be the 2nd of the previous month. (so I need the below option currently to be 2021-11-02), I am trying to use regexreplace to replace the middle part with current month -1, but i am quite new to regexreplace and struggling. Any help is appreciated.
Thank you!
Nat

[Sebastiaandb · Accepted solution]

Hi @nataliad18 ,

Here you go:

Datetimeformat(DateTimeAdd(DateTimeNow(),-1,"months"), "%Y-%m-02")

Greetings,

Seb

[nataliad18]

Thanks @Sebastiaandb worked perfectly