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

Hi @nataliad18 ,

Here you go:

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

Greetings,

Seb

Regexdate.yxmd