Powerplay Transformer TR0806 The date is invalid

[Drepso]

Powerplay Transformer 7.0

Problem: TR0806 The date is invalid

I am trying to use a .csv file as a datasource within my model. I have selected source type as delimited-field text with column titles.

An example of the date format is: 01/07/1993 12:00

I have tried using Data Class = Date & Unspecified and also Time = DMY & Predefined.

None of these options work. I have actually tried all the options and cannot get the appropriate date format.

The only way I can get transformer to read the datasource is if I use autodesign and create a new model. Unfortunately I am enhancing a model with a new datasource and can’t seem to find a fix for this.

Can anyone help with the above.

Thanks in advance

 

[Draoued]

If managed to use it in a new model.
Check how the date field is defined in the new model.

Or if you use the data source view , you can preview your source data, and see what is the date format.