Find previous month using YYYY-MM string

I have a date in the format YYYY-MM which is formatted as a string. I want to find the previous month, How would i do this?

So 2021-06 > 2021-05, 2022-01 > 2021-12

Thanks!

Developer

Accepted answers

You can use formula like below. Covert it to date, minus 1 month and convert it back to fromat

DateTimeFormat(
DateTimeAdd(DateTimeParse([Month],"%Y-%m"),-1,"month")
, "%Y-%m")

Workflow:

Hope this helps 🙂

You can use formula like below. Covert it to date, minus 1 month and convert it back to fromat

DateTimeFormat(
DateTimeAdd(DateTimeParse([Month],"%Y-%m"),-1,"month")
, "%Y-%m")

Workflow:

Hope this helps 🙂

Hi nsarayar,

Here is the workflow. Hope this helps 🙂

@atcodedog05 perfect thanks!

@Vaithi - great thank you so much!!