Problem: I don't know how to format data for dates Solution: mm-dd-yy (sliding window pertains) mm-dd-yyyy mm/dd/yy (sliding window pertains) mm/dd/yyyy Month dd, yy (sliding window pertains) Month dd, yyy dd-Mon-yyyy dd.mm.yy (sliding window pertains) yyyy mm dd mon dd (year is current year) dd mon (year is current year) mm dd (year is current year) mm dd yy (sliding window pertains) mm dd yyyy now today tomorrow yesterday InterBase uses a sliding window of 50 yearsfor dates. So any time you enter a 2 digit year the century of the date is determined by this sliding window. For example, in the year 2000, any date with a year of 0-49 is assumed to be in the 21st century. Any date with the year 50-99 is assumed to be in the 20th century.
Last Modified: 15-DEC-00