Michelle,
You will need something for February 29, 2000 since CTOD("02/29/00") will give an error.
Something like:
IIF(CharacterDateField = "02/29/00", ;
CTOD("02/29/2000"), CTOD(CharacterDateField))
>>
>>>I am trying to make an old 2.6 app Y2K compliant. What I would like to do is have it recognize 00 and up as 2000+, but not put the century in. They have character based dates, and I'm afraid if it sticks the century in that it won't work. Is this possible?
>
>They're 2 digit years and I'd like to keep them that way. Ambiguity is not a problem. All dates are either the current year or the previous year. All I really need is to have CTOD("01/01/00") (gr than sign) CTOD("12/31/99") be true.
>
>Thanks,
>
>Michelle