Simple use expression transformation and make all the inputs into the date format given. Add a condition like
IIF(ISNULL(V-date),SYSDATE(),
IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')
This is my idea. It helps you hopefully....thx

1 User has rated as useful.
Login to rate this answer.
IIF(ISNULL(V-date),TO_DATE(SYSDATE, 'dd-mon-yy')
IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')
Login to rate this answer.