Changing String to Datetime, Columns are coming in as null

[wonka1234]

Hi,

Trying to convert these "strings" to "datetime" , however it is null after changing types.

before:

change:

after:

[DataNath · Accepted solution]

@wonka1234 Alteryx reads dates (and date time fields) in the format YYYY-MM-DD (+ HH:MM:SS if DateTime), so you’ll need to convert these into suitable dates. You can do this with a few DateTimeTools where you just select the format of the incoming string, or you can use a Formula tool with DateTimeParse([Field], ‘%m/%d/%Y %H:%M) - assuming the bit at the end is hours:minutes - doing this 3 times in the same tool with each of the date fields replacing [Field], changing the output data type to DateTime.

[binuacs]

@wonka1234 one way of doing all these fields in to date format using the multi-column tool