Date Conversion

[Dom]

Hello, I need to convert the Date of Birth date from 05/28/1956 to yyyymmdd. I'm confused as to which date format to use.

[MarqueeCrew · Accepted solution]

The string needs to be converted to a date.

YYYY-MM-DD is the format of data that will populate into a DATE field.

RIGHT([Field],4)+'-'+SUBSTRING([FIELD],3,2)+'-'+LEFT([FIELD],2)

is the formula to use on a string that looks like:  MM-DD-YYYY

[MattD · Accepted solution]

Hey Dom!

Try datetimeparse([Test],"%m/%d/%Y").

Best of luck,

Matt

[michael_treadwell · Accepted solution]

You need to use the DATETIMEFORMAT() function. That being said, DATETIMEFORMAT() will only format a DateTime field. You will first need to make sure that 05/28/1956 is a DateTime because Alteryx will probably read it as a String.

As for the operators to use, you can find examples of those here: http://downloads.alteryx.com/Alteryx8.6.2/WebHelp/Reference/DateTimeFunctions.htm