How to trim year

[haroon_sa]

i'm unable to trim year from the date.

i'm having  1994-02-24

but i need this 1994(year alone) using formula tool.

 which formula should i use to get this output.

[LordNeilLord · Accepted solution]

Hi @haroon_sa

Try DateTimeFormat([Your_Date_Field], "%Y")

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[BenMoss]

You could also try left([date],4)

Ben

[haroon_sa]

No it's not working..... Any other idea

[haroon_sa]

Thanks @LordNeilLord 

I got it

[LordNeilLord]

@haroon_sa

This is a really good resource for DateTime Functions in Alteryx:

https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm