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
Deano478
11 - Bolide

@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
13 - Pulsar

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")))

 

FrederikE_0-1685448088030.png

 

chiragpatel_1
8 - Asteroid

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

DarshanaJ
5 - Atom

Very helpful. Thank you.

Labels