Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

change in date format

Rajesh_27
7 - Meteor

Dear Members,

 

I am trying to change the date format from 2024.01.03 to just 2024, can you please help.

1 REPLY 1
aatalai
15 - Aurora

Does alteryx recognise that as a string or date?

 

If string then use this in the formula tool Left( [Field],4), if date then use the formula tool with the following expression DateTimeYear( [Field] )

 

Hope this helps

Labels
Top Solution Authors