Date Handling¶

How to access the dialog

  • Main Menu | Tools | Preferences

  • Main Menu | Tools | Generate Scripts | SQL Script for Creating Table, Preferences Button

  • Main Menu | Tools | Generate .INT | .INT File from .DAT, Preferences Button

  • Filelist dialog, Convert Database Button, Preferences Button

Allows you to set how DataFlex displays and handles dates.

  • Use Epoch Year: The Use Epoch Year setting is used when the DataFlex database contains 2-digit years. All dates are saved as 4-digit dates on the target database and any year on or before the epoch year value is treated as a new year in the millennium 2000.

  • Program Displays 2-Digit Year: If your program displays 2-digit years and you want a 4-digit year extracted from the table on the target server displayed, uncheck the Program Displays 2-Digit Year option. After retrieving the data field, the driver converts the date to 2-digit year and returns just the last two digits to the runtime for display.