Str2date "01-JAN-2015"

CloverDX Platform
1

Hello -

How can I convert the string to date with the source format being “01-JAN-2015”?

I tried “dd-mm-yyyy” and “dd-mmm-yyyy” but no luck,

Perri

2

Hi Perri,

The Month has to be in capitals :


	$out.0.field1=str2date($in.0.field1, "dd-MMM-yyyy");

I hope this helps.

3

More information on date & time format patterns is available in CloverETL User’s Guide.