Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
attached
Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct
Hi,
attached
Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct