Search results
Results from the WOW.Com Content Network
This problem can be seen in the spreadsheet program Microsoft Excel as of 2023, which stores dates as the number of days since 31 December 1899 (day 1 is 1 January 1900) with a fictional leap day in 1900 if using the default 1900 date system. Alternatively, if using the 1904 date system, the date is stored as the number of days since 1 January ...
The "Body dates to mdy" button ensures consistency by removing all instances of dmy dates anywhere in the article in favour of mdy. But because some editors prefer their reference dates in yyyy-mm-dd format, the "Body dates to mdy" button respects this preference by not flipping yyyy-mm-dd dates within references.
National standard format is yyyy-mm-dd. [161] dd.mm.yyyy format is used in some places where it is required by EU regulations, for example for best-before dates on food [162] and on driver's licenses. d/m format is used casually, when the year is obvious from the context, and for date ranges, e.g. 28-31/8 for 28–31 August.
Ongoing maintenance of date formats may one day be carried out by bots on articles already tagged with templates ({{use dmy dates}} or {{use mdy dates}}) which help to identify the correct format. Potentially ambiguous dates, using slashes or full stops (6/7/1961, 12/07/1986, 6.7.1961, 12.07.1986) are re-appearing on some thousands of pages ...
If a section title contains a link in a format such that the date formatting feature applies, the section title is user-dependent. However, for section linking this would require a link target that is correspondingly user-dependent, which does not seem possible with the current software without some special extension.
Microsoft Excel (using the default 1900 Date System) cannot display dates before the year 1900, although this is not due to a two-digit integer being used to represent the year: Excel uses a floating-point number to store dates and times. The number 1.0 represents the first second of January 1, 1900, in the 1900 Date System (or January 2, 1904 ...
Main page; Contents; Current events; Random article; About Wikipedia; Contact us; Pages for logged out editors learn more
An alternative method of date auto-formatting - preferably one which incorporates a 'date format' code once in the article, and then uses that throughout (but could be over-ridden by a user's own preferences if that was their choice) - would be far more elegant than the present approach. MarkyMarkD 19:54, 29 November 2008 (UTC)