StringToDate for dd/mmm/yy resulting in 1900 instead of 2000
Posted: Mon Nov 15, 2010 8:18 pm
Hi,
I have data in input as 20/Sep/03. When i try to convert this to date using String to Date function with %dd/%mmm/%yy format it is converting the date as 1903-09-20
But I need 2003-09-20.
What additional things do I need to do to convert the dates to 21st century dates instead of 20th?
Thanks
I have data in input as 20/Sep/03. When i try to convert this to date using String to Date function with %dd/%mmm/%yy format it is converting the date as 1903-09-20
But I need 2003-09-20.
What additional things do I need to do to convert the dates to 21st century dates instead of 20th?
Thanks