Control Find or RIGHT/MID/LEFT function ?

[Mizzness]

All.

I have a set of data in date format (mm/dd/yyyy).
I need the macro to find "19" & replace it with "20". Simple enough except "19" shows up in the dd section.
In short, I need to change all of the data in years only from 19 to 20 while leaving the day portion alone.

Control/Find changes all data that is 19 to 20. Can the RIGHT, LEFT or MID function be combined or used alone ?
I'm not sure how to write this bit of code.

Any & all help is appreciated.

 

[SkipVought]

Hi,

You really do not need to use STRING functions. Dates are NUMBERS. faq68-5827

If the YEAR is less than 2000 then assign DateSerial(year(YourDate)+100, Month(YourDate), Day(YourDate))

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[ClulessChris]

I'd opt for RegEx depending on how the data is stored (if it's inbedded in a string regex, if we're talking a table then this is another story)

Never knock on Death's door: ring the bell and run away! Death really hates that!