Find previous month using YYYY-MM string

[nsarayar]

Hi

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!

[atcodedog05 · Accepted solution]

Hi @nsarayar

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 🙂

[Vaithi]

Hi nsarayar,

Here is the workflow. Hope this helps 🙂

[nsarayar]

@atcodedog05 perfect thanks!

[nsarayar]

@Vaithi - great thank you so much!!