How to make my date load script can record from Day >13 ?

[paulyeo11]

How to make my date load script can record from Day >13 ?
Hi All

My excel CSV date field :-

Posting Date
01/13/2020

My load cript :-
Date( Date#([Posting Date], 'DD/MM/YYYY'), 'DD/MM/YYYY') as [date],

My issue is above script can only recode date from Jan 1 to 12. Above 01/13/2020 unable to recode.

Paul Yeo

[paulyeo11 · Accepted solution]

Hi All

After post the question , then i notice that i should make first date format MM/DD , instead of DD/MM.

it work fine now.

Paul