StringToDate for dd/mmm/yy resulting in 1900 instead of 2000

[rroy2]

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

[rroy2]

use format as "%dd/%mmm/%2000yy"