>Okay, if "Try to avoid CTOD and CTOT. They are not Y2K compliant. In fact, depending on the setting of SET STRICTDATE, the compiler may complain." is true, what should be done, when you are trying to convert character date stings (or datetime strings) from tables into other tables, and the format of the string depends on the Regional settings of the computer [i.e. English(American) MM-DD-YYYY versus French (Standard) DD-MM-YYYY]

Beth

You can use them, with care. A better or more secure way would be to parse the date and build a date-safe command like DATE(yyyy,mm,dd) or using the strict date format: {^yyyy-mm-dd[,][hh[:mm[:ss]][a|p]]} (e.g. {^2003-01-16}). The presentation of the internal date depends on settings (see SET DATE in the help files).

HTH