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.
Hi @haroon_sa
Try DateTimeFormat([Your_Date_Field], "%Y")
@LordNeilLord
Part time Tableau, Part Time Alteryx. Full Time Awesome
You could also try left([date],4)
Ben
Thanks @LordNeilLord
I got it