Dessagregate YYYY/MM/day or similar

[buitrago_98]

Hello team

How can I Dessagregate YYYY/MM/day or similar? For example, I have 8/17/2022 and want a column with 2022 but still in datetime format.

Thanks!

[DataNath]

@buitrago_98 do you mean something like this, where you just strip the date back to the part that you're interested in? If so, the DateTimeTrunc() function is good for that - you just supply the date field and date part you want. Here's an example of Year and Month:

[Qiu]

@buitrago_98 
If you mean you want only "2022" to be datetime format, that will not be possible for alteryx.