Page 1 of 1
Convert date from mm/dd/yyyy to yyyy-mm-dd
Posted: Wed Feb 22, 2012 8:28 am
by 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.
Re: Convert date from mm/dd/yyyy to yyyy-mm-dd
Posted: Wed Feb 22, 2012 8:33 am
by 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.
Posted: Wed Feb 22, 2012 8:36 am
by 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.
Posted: Wed Feb 22, 2012 7:11 pm
by 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.