Want to get Automatically "FY" bases of Dates

[Srawat]

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.

Thanks

[Christina_H]

If your dates are in date format:

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

[DataNath · Accepted solution]

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

[ChrisTX]

In this post:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-drop-down-list-boxs-to-populate-...

Check out the "Date_Solution.yxzp" posted by @meads 

Chris

[Srawat]

Thank you so much! It works fine.