Format Date

I am trying to write a formula that will show the dates as follows (ie always 7 digits)

2021001

2021002

2021003

2021010

2021011

Depending on current month -1

ie now would be 2021008 so I would need to consider when I get to January it would need to be 2021012

Please can someone help.

thanks so much

Date Time

Help

Accepted answers

Use formula like below

DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"month"),"%Y0%m")

Workflow:

Hope this helps : )

I meant now would be 2021007! apologies

Use formula like below

DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"month"),"%Y0%m")

Workflow:

Hope this helps : )