DSXchange

Hi,
How can I change date format from "YYYY-MM-DD" to "DD-MON-YY" in parallel jobs.

Thanks
Vinoth

So... as strings, I assume?

DateToString(DSJobStartDate,"%dd-%mmm-%yyyy")

I used DSJobStartDate as an example, you can substitute it with your input date.

Date data types are stored in a binary form, so do not have formats.
To convert from one string representation to another, convert to and from Date data type with appropriate format strings. That is, use StringToDate() and DateToString() functions, assuming you're using a Transformer stage. Or date_from_string() and string_from_date() if you're using a Modify stage.

Thanks. You guys rock as always..