finding the quarter across years

[praneshsapmm]

Hello ,

I have this requirement . 

Iam trying to find the 'closing month' with this formula : 

DateTimeFormat(DateTimeToday(),"%m") -1 

and attach to the year to generate output : closing month + year . 

for example : 092020 .

Untill now it is working , but when i run this solution in January 2021 for the closing month on December 2020 how does this work . 

Any help .

[echuong1 · Accepted solution]

You can use the datetimeadd() function to find the previous month. From there, you can use the datetimeformat() to put it into MMYYYY.

[atcodedog05]

Hi @praneshsapmm 

Here is a formula using DateTime functions. Considers previous month then formats

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

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[praneshsapmm]

Hi ,

Thanks for the response . 

Just wondering will this give the result across two different years . 

For example : If iam running in Januaary 2021 , then will it show previous month as 122020. 

Thanks

[estherb47]

Hi @praneshsapmm 

The DateTimeAdd function will work from year to year. I've marked the first solution so that others who have the same question can find an answer.

Cheers!

Esther