Convert date from mm/dd/yyyy to yyyy-mm-dd

[Marley777]

Hi, thanks for reading. What's the best way to convert a date from mm/dd/yyyy to yyyy-mm-dd? I tried the forum, but not seeing a specifc option for my situtation. Any help is greatly appreciated.

[dsusersaj]

Extract MM,DD and YYYY from your date and then make a string like YYYY'/'MM'/'DD .Then convert that string to date using StringToDate function.

[chulett]

Neither one of those is a date but rather strings. So either cut it up and put it back together the way you want or go StringToDate() and then DateToString() with the proper format masks.

[qt_ky]

See the Parallel Job Developer's Guide Chapter 2. Designing parallel jobs. Look under the "Date and time formats" section for all the possible date and time format tags to choose from.