Date/Month format

Help Studio
, ,
2

@kaurM

Please try this

For quarter
If({6,9,12,3}.Contains(Now.Addmonths(-1).Month),If(Now.AddMonths(-1).Month=6,"Q1", If(Now.AddMonths(-1).Month=9,"Q2", If(Now.AddMonths(-1).Month=12,"Q3","Q4"))) + "-Constant-FY",Now.Addmonths(-1).ToString("MMM-")) + If({1,2,3}.Contains(Now.AddMonths(-1).Month),Now.addMonths(-1),Now.addmonths(-1).Addyears(1)).ToString("yy")

Hope this helps

Cheers