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.
Solved! Go to Solution.
Hi @haroon_sa
Try DateTimeFormat([Your_Date_Field], "%Y")
Part time Tableau, Part Time Alteryx. Full Time Awesome
You could also try left([date],4)
Ben
No it's not working..... Any other idea
Thanks @LordNeilLord
I got it
This is a really good resource for DateTime Functions in Alteryx:
https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm