OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Dates: Use YYYY-MM-DD or DATE(), don't assume an epoch or locale


Just a reminder - when creating test cases, if you need a date,
please always use YYYY-MM-DD as a text format or the DATE()
function; both are locale and epoch neutral.

Please don't use formats like "01/02/2005", because that could mean
EITHER January 2 or February 1, depending on the locale.
And obviously don't use particular sequence numbers (!).

--- David A. Wheeler 


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]