We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

fy date into month year

chiragpatel_1
8 - Asteroid

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

13 REPLIES 13
FrederikE
13 - Pulsar

Hey @chiragpatel_1,

 

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

FrederikE_0-1685024782289.png

 

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

 

 

Deano478
11 - Bolide

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

 

 

Deano478_1-1685025616396.png

 

binuacs
20 - Arcturus

@chiragpatel_1 similar solution as others

binuacs_0-1685034660557.png

 

chiragpatel_1
8 - Asteroid

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

FrederikE
13 - Pulsar

@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
8 - Asteroid

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

FrederikE
13 - Pulsar

@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? 

FrederikE_1-1685447461065.png

 

 

Deano478
11 - Bolide

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

 

Deano478_0-1685447625175.png

 

chiragpatel_1
8 - Asteroid

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

Labels