Date-Time to Number
- 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
I need to convert 1/3/1900 12:00:00 AM to 72.00 through alteryx. See attached file for examples in excel.
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This worked, but I might be back with another question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @danilang :) a little bit of playing around with the dates in Excel did the trick
@jnewland1234 - could you perhaps just mark the solution as accepted so that others know that it is resolved :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I accepted, but I am still having trouble with my database. Mainly because my data is coming in, through my macro, as a string so when I go to convert to date/time it ignores anything under 24 hours.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jnewland1234 - could you then perhaps first convert it to datetime format with the datetime tool before doing the conversion steps?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried. The problem is that the data that is coming in is in String so when I try to convert to Date/Time using select the under 24 hours time defaults to Null. I think I have almost figured out how to convert but it's somewhat complicated and I have my fingers crossed. Do you have a formula that would convert string to date/time format?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jnewland1234 - try the date time tool under the parse section of tools. This allows you to convert string to date/time without loosing anything