Error while transforming date from import set table to target table

Obito
Tera Expert

‎10-18-2023 04:34 AM

Hi All,

 

I got below error while transforming date from import set table to target table 

"Unable to format 02-JUN-22 using format string yyyy-MM-dd HH:mm:ss for field u_start_date"

 

How can I map this field. 

 

Thank you.

0 Helpfuls
  • 258 Views
2 REPLIES 2

Sandeep Rajput
Tera Patron
Tera Patron

‎10-18-2023 04:41 AM

@Obito This error is appearing because the date format you are using for the date field is yyyy-MM-dd HH:mm:ss  whereas in your source data the date is in DD-MMM-YY format. Either you will have to change your target date format or you will have to change the source date format to match with the target date format and the error will disappear.

Jaspal Singh
Mega Patron
Mega Patron

‎10-18-2023 04:50 AM

Hi,

Open the field map for the data source and pass the relevant date format the target field accepts.