Date Conversion

[PN]

Hi,

I have an issue by converting a format of dates that omits 0 at the beginning of the month and for the first 9 months.

See also my expression for the formula. FYI the input string also contains the hour with AM and PM.

Any idea on how to make this format recognized would be more than welcome! 

[MarqueeCrew · Accepted solution]

@PN,

You'll create a new field with a DATE type.  Here is the formula:  

DateTimeParse([interview_start],"%m/%d/%Y")

You were very close.

The output will appear like this:

Cheers,

Mark

[pcatterson · Accepted solution]

To make a String field understood by Alteryx as a DateTime, you would use a DateTimeParse tool.  This will convert it to a YYYY-MM-DD format that is understood by Alteryx and then you can perform expressions with it.  To trim off a time, you can use the substring, but remember that the character index starts at zero.  See the attached.