Date Conversion
- 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
The dates in this file are formatted in some custom format and when i try converting it nothing works it just changes to null.
Solutions Attempted:
1) Using the select tool to manually change the date
2) I used the following formula --> DateTimeParse([Raw Date], "%b %d %Y")
Please see attached for the example - any help would be greatly appreciated.
I have include a formula to check for date differences - hopefully the formula will work after the update.
Solved! Go to Solution.
- Labels:
- Custom Tools
- Data Investigation
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jonathanzadeh ,
What format are you wanting the dates to be in? The standard Alteryx format for dates of yyyy-MM-dd (e.g. 2019-12-31) or a custom format Mon dd yyyy (e.g. Dec 31 2019)? Either way I think the DateTime tool will help you immensely, but want to understand what you're trying to achieve so I can build out an example for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @jonathanzadeh
1. Date Time calculations need Date Time Type (use the DateTime Parse Tool to convert from text to DateTime)
2. Proper argument is DateTimeDiff([Maturity_Date],[Price_Date],'duration'), where duration can be any measure of time (days, months, minutes, etc.,)
Please mark the below as a solution + like, if this works for you.
DateTime config example
Formula Tool argument
Cheers!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the MM/DD/YYYY format.
I would like to use the date time diff formula as well.
Hence, it should be 12/31/19 minus 12/28/19 equal to 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Would you be able to provide a YXZP using my example with your resolution?
Not sure i follow it
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/9780FA8738778E76CAA545EFAA4CDA4D/responsive_peak/images/icon_anonymous_message.png)