Can't apply format ...

I'm not sure what I'm doing wrong but all of the sudden this transformer is rejecting all record with this error "Record rejected can't apply format ... see attached. I have tried both ways to set the format and not set the format in the validator and transformer and still rejected it. I check both validator and transformer for the dates and it seems to correct .. see screen. Not sure what to do

This is normal

When data is loaded into Date/Time fiels AETL assumes that it is in yyyy-mm-dd etc format. In your case it is not so it is failing

Solution: use Dateformat function

M