SOLVED
Change date format
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SH_94
11 - Bolide
‎12-22-2022
05:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI community,
May i know how can i change the format below to YearMonth in number?
Input
May 2022
Sep 2022
Output
202205
202209
Many thanks
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
4 REPLIES 4
21 - Polaris
‎12-22-2022
05:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SH_94
The straightforward way to use 2 DateTime tools.
grazitti_sapna
17 - Castor
‎12-23-2022
12:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ShankerV
17 - Castor
‎12-23-2022
02:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SH_94
This can be achieved with the help of Datetime function.
Below link will help to get more insight on the datetime function.
https://help.alteryx.com/11.7/Reference/DateTimeFunctions.htm
https://help.alteryx.com/20223/designer/datetime-functions
Many thanks
Shanker V
Felipe_Ribeir0
16 - Nebula
‎12-23-2022
03:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SH_94
One way of doing this, first use the datetimeparse formula to convert your date to the default date format that Alteryx understand (YYYY-MM-DD), and then convert this date to the format that you need.
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)