Use this function if the database you use delivers only a two digit date based on some "base date". The number argument should be the base date used by the database for its internal year calulations (see the database documentation).

The function converts a date into a 4 digit date according to a number which should be in the range [0,..,99]. The date argument can be a 2 or 4 digit date, however, only the last two digits "xy" are significant. If the value of the last two digits "xy" (i.e. the last two digits interpreted as an integer) are smaller or equal to Number, then the date returned is "20xy"; otherwise the date returned is "19xy".

DateTimeTo2000( DateTimeString )

Year 2000 Date

DateTimeTo2000(CDateTime(1992,12,12,1,20,1), 99)
-> 2092/12/12 1:20:01