We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎02-14-2024 03:27 AM

Dear Members,

 

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

Labels:
Reply
0 Likes
1 REPLY 1
aatalai
15 - Aurora
‎02-14-2024 08:56 AM

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

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All