Date format change from YYYY-MM-DD to DD-MM-YYYY
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
munipavankumar
8 - Asteroid
‎04-18-2024
10:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have a date format like YYYY-MM-DD with a Date Datatype. But I need it like DD-MM-YYYY format only with Date Datatype. I have achieved it using Formula Tool. The problem is, it is in String format but when I convert it to Date, the values are showing null. I have attached sample screenshot for your reference. Can anyone please help on this. Many more thanks.
Labels:
- Labels:
- Date Time
3 REPLIES 3
Qiu
21 - Polaris
‎04-18-2024
11:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Date format in Alteryx is YYYY-MM-DD.
If you force a string which is not "YYYY-MM-DD" format, it will thow a warning and get null value eventually.
‎04-18-2024
11:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, @Qiu Thanks for your response. my problem is the same. But I need to that DD-MM-YYYY format with Date data type. How we can achieve that.
Qiu
21 - Polaris
‎04-18-2024
11:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@munipavankumar
I am sorry but you can not do that with Alteryx.