Date format

[upaliwije]

Hi Friends,

I have some dates entered in wrong  with wrong year in my data set as shown below

Wrong	Correct
2/12/0020	2/12/2020
1/29/0020	1/29/2020
2/10/0020	2/10/2020
1/27/0020	1/27/2020
2/5/0020	2/5/2020

I want to change the year 0020 to 2020 in my all date fields while loading the data . Kindly help me with how to write the data load  script it please.

[Taoufiq_Zarra · Accepted solution]

Hi,

attached

Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct