Reformat Dec 15 2011 3:17PM as timestamp

tbtcust · Post by **tbtcust** » Mon Feb 20, 2012 7:38 am

I have a date in the following format Dec 15 2011 3:17PM.

How can I reformat the date as a timestamp (yyyymmddhhnnss)?

Thanks in advance for any help.\

chulett · Post by **chulett** » Mon Feb 20, 2012 9:17 am

Use StringToTimestamp() if you actually want a timestamp. For the format you posted, do that and then convert it back to a number.

qt_ky · Post by **qt_ky** » Tue Feb 21, 2012 2:17 pm

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.