Alteryx Designer Desktop Discussions

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

Want to get Automatically "FY" bases of Dates

Srawat
8 - Asteroid

Hi,

 

I have a dates in one column and on that bases want to get automatically "FY22 ,FY23  ..... etc. Financial year start from May and end April. Please advise if any formula will work.

 

Srawat_0-1664449394650.png

 

Thanks

4 REPLIES 4
Christina_H
14 - Magnetar

If your dates are in date format:

'FY'+tostring(DateTimeYear([Date])+if DateTimeMonth([Date])<5 then 0 else 1 endif)

DataNath
17 - Castor

Couple of ways to do this as I committed to the rabbit hole of the first one!

 

DataNath_0-1664450398328.png

ChrisTX
15 - Aurora
Srawat
8 - Asteroid

Thank you so much! It works fine.

Labels