Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO Mission Control
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
Free Trial

Alteryx Designer Desktop Discussions

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

Change the Date format

SurbhiMittal
7 - Meteor
‎03-09-2023 02:12 AM

Hi Team,

 

I have column named date in the following format i.e. 10-01-2023 (dd-mm-yyyy) as an input.

 

I want to create new column as "Period" in the output as Jan-23.(mmm-yy).

 

Please let me know the right formula to use for the same.

Labels:
Reply
0 Likes
1 REPLY 1
ShankerV
17 - Castor
‎03-09-2023 02:15 AM

Hi @SurbhiMittal 

 

Please use

datetimeformat(datetimeparse([Field1],"%d-%m-%y"),"%b-%y")

 

ShankerV_0-1678356975978.png

 

Many thanks

Shanker V

Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All