Incremental load with mixed date format , and add data with above the max date and below the maxdate

[Kohli]

I have single table with Mixed date. I need create a incremental load on that table. I need to add updated records for that table.  My customer add new records as well as some times missing old days records also enter. Please suggest me, how can i create incremental load for that..

Ex: 

Date:

31/12/2018,

01-01-2019,

18-01-19

like these , and new records enter above and below the max date of the table..

[PrashantSangle]

try below

where alt(date#( dateField, 'YYYY/MM/DD' ),
date#( dateField, 'MM/DD/YYYY' ),
date#( dateField, 'MM/DD/YY' ))>'$(vMaxDate);

Regards
Prashant Sangle

[Vegar]

To fetch date with different format use ALT().

ALT(
date#( dateField, 'DD/MM/YYYY' ),
date#( dateField, 'DD-MM-YYYY' ),
date#( dateField, 'DD-MM-YY' )
)

This method works as long you don't have overlapping formats such as 'MM-DD-YYYY' together with 'DD-MM-YYYY'. This is trouble when having a date like 01-02-2019 that fits into both formats.