Date Conversion

[rajkraj]

I need to convert mmddyy format to mm/dd/yyyy

071007 -->7/10/2007

I tried stringtodate(date,'%mm%dd%%yy)-->out result is 7/10/1907 but i need 7/10/2007

Thanks in advance.

Raj

[sud]

The default representation from year in yy to yyyy format happens in that way(taking 1900 as base year). You need to give 2007 as input instead of 07 ... that can be done using string manipulations.

[us1aslam1us]

Try the %year_cutoffyy option while converting instead of just %yy.

[ccatania]

Try StringToDate(inputdatefield, '%mm%dd%2000yy")

[ccatania]

Try StringToDate(inputdatefield, '%mm%dd%2000yy")

[rajkraj]

Thanks guys...its working now