How to change the date format and keep the date type
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone!
I have a quick question regarding how to change the date format and keep the date type.
Let's say... I have a column that has a string type with the date value of dd/mm/yyyy. I used datetime tool to change this column type from string to date but the format has changed to yyyy-mm-dd. Then, I used the dateformat formula to edit the date value format but the type of this column has changed to the string type by doing this. Is there a way to have the date structure of "dd/mm/yyyy" and have a date type?
Appreciate any awnswers! Cheers! 🙂
Solved! Go to Solution.
- Labels:
- Custom Tools
- Datasets
- Date Time
- Help
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx supported date format is only yyyy-mm-dd changing to any other format will change it to string.
If you are overwriting/appending the data to the same excel file you can use method of preserve output formatting of output tool. You can format your date column in excel (would be needed only once) as required and each time alteryx writes to that excel it will be displayed in the same format.
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
