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

[FrederikE]

Hey @chiragpatel_1,

You could do something like this (202301 is jan and not apr, right?): 

Why it works this way: https://help.alteryx.com/20231/designer/datetime-functions

[Deano478]

Hey @chiragpatel_1  similar to @FrederikE solution The date 202301 would be Jan and not April:

[binuacs]

@chiragpatel_1 similar solution as others

[chiragpatel_1]

Thanks all  below but i rlly need it t say apr as it is a financial year format.

[FrederikE]

@chiragpatel_1,

Can you please specify how this format is built? This is certainly not a typical financial year format - I can't see the logic behind this. Why does "202301" reference to April? What would 202302 reference to then? 

[chiragpatel_1]

2023 being the year and 01 being the start of the financial year which is April, 202302 being may and so on.

[FrederikE]

@chiragpatel_1,

Ah, I see. Then you can modify the date by 3 months and it should be corrected. 202301 will be April, 202310 will then be Jan - is it expected like that? 

[Deano478]

@chiragpatel_1  this would work for your case aswell @FrederikE that's a neat approach:

[chiragpatel_1]

can you not do it without date time tool and just via the formula?