Formatting of date
- 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 All,
I need to format below dates to "dd-mm-yyyy" (example in should be column). When using datetimetool I'm having error that the date in the below is not in valid format.
Thanks!
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Belletmns , try this.
Formula
DatetimeFOrmat(DateTimeParse(Date,"%m/%d/%Y"),"%d-%m-%Y") |
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you can use the datetime formatting option in formula tool "DateTimeFormat([DateTime_Out], "%d-%m-%Y")" but it will be in a string format only because Alteryx's default date format is "YYYY-MM-DD"
Regards,
Himanshu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have the following data and need it to be read as a date. I changed the Value Date to "date" under type, but it still comes up as Null.
Thanks, Todd
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ttiverson98
You can use the DateTime or formula tool to convert it to a date. Alteryx only reads dates in yyyy-mm-dd format, simply updating the data type won't work because your data is not in the correct format. See attached, both tools are essentially doing the same thing, creating a date field by telling alteryx the data is structured as %Y%m%d.
More info on date functions: https://help.alteryx.com/current/designer/datetime-functions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ttiverson98,
You need to tell Alteryx how to read this date. I have prepared a workflow for you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You, works perfectly.
