Date and Time format

[Dom]

Is this date and time format possible mm/dd/yyyyThh:mm:ss? 

[michael_treadwell · Accepted solution]

If you are trying to read dates formatted as mm/dd/yyyyThh:mm:ss into Alteryx you will first need to format the string to remove the 'T' and use the DateTime tool to convert from String to DateTime field.

If you have a DateTime field and you want to convert it to the format mm/dd/yyyyThh:mm:ss you will use the DATETIMEFORMAT() function

DATETIMEFORMAT([datetime], '%m/%d/%YT%H:%M:%S')

[jdunkerley79]

If you want to read these dates in, I would use a RegEx tool to shuffle the parts and then a select to change type:

Attached flow of what I mean

[Dom]

Thank you, this worked!smileyvery-happy: