Output Date Formats:


The @AGEDATE, @DATECONV, @DATEPLUS, @EASTER, @FILESTAMP, @HOLIDAY, @INLIEU, @MAKEDATE, @NEXTDATE, @NEXTDOW, and @PICKDATE functions can return dates in any of these formats:

fmtFormatExample
0local date formatvaries; 11/04/08 in the U.S.
1mm/dd/yy11/04/08
2dd/mm/yy04/11/08
3yy/mm/dd08/11/04
4ISO 86012008-11-04
5ISO 8601 week-day2008-W45-2
6ISO 8601 ordinal date2008-309
16MS-DOS day number+10535
17using English wordsTuesday, November 4, 2008
18T format (offset from today’s date)
19ANSI day numberA+148962
20ISO8601, packed20081104
21days since 1970-01-01U+14187
32Windows user locale “long date” formatvaries; mardi 4 novembre 2008 in France
256local date format, four-digit yearvaries; 11/04/2008 in the U.S.
257mm/dd/yyyy11/04/2008
258dd/mm/yyyy04/11/2008
259yyyy/mm/dd2008/11/04

Formats 0 through 3 return two-digit years, for compatibility with Take Command’s native behavior. Where compatibility is not an issue, I recommend using formats 256-259 instead. These formats are equivalent to 0-3, but return four-digit years. (A note in TakeCmd.h suggests that TCC supports similar formats internally; unfortunately, this capability doesn’t seem to be available to the user.)

The LONGYEARS command can be used to display four-digit years in formats 0-3, making them functionally identical to formats 256-259.

MS-DOS day numbers are based on January 1, 1980 as day 0; dates before 1980 will have negative MS-DOS day numbers. ANSI day numbers use January 1, 1601 as day 1.

Note that all of these output formats except for #17 and #32 are also valid input formats.