DSXchange

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.\

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

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.