fy date into month year

[chiragpatel_1]

Hi 

I have a field with various fy dates listed as eg. 202301, 202302  etc... int 32 format, 202301 being apr and I want that to say Apr-23.

What would  be the formula for it pls.?

Thank you

[Deano478]

@chiragpatel_1 I don't know if my approach was what you wanted but it's two formulas one other question do you plan on using these dates in calculations at all later on?

[FrederikE · Accepted solution]

Hey @chiragpatel_1,

Sure, you can do that aswell - I just prefer to split it out to keep it better understandable.

But this formula alone will also do: 

DateTimeFormat(DateTimeAdd(DateTimeParse(ToString([Date]),"%y%M"),3,'Months'),"%b")+"-"+ToString(DateTimeYear(DateTimeParse(ToString([Date]),"%y%M")))

[chiragpatel_1]

Brilliant, thank  you so much, that is a big formula.

[DarshanaJ]

Very helpful. Thank you.