Date/Time data display is region-specific; in other words, the data is displayed according to local standards for date and time display. The following are the data types that are included in Date/Time data:
- Date: This contains an integer number, which is interpreted as a date ranging from January 1, 1754 to December 31, 9999. A 0D (numeral zero, letter D) represents an undefined date (stored as a SQL Server DateTime field), which is interpreted as January 1, 1753. According to the developer and IT pro help, Business Central supports a date of 1/1/0000 (presumably as a special case for backward compatibility, but not supported by SQL Server).
A date constant can be written as the letter D, preceded by either six digits in the format MMDDYY or eight digits as MMDDYYYY (where M for month, D for day, and Y for year). For example, 011917D or 01192017D both represent January 19, 2017. Later, in DateFormula, we will find D interpreted as day, but here, the trailing D is interpreted...