On Oct 13, 2006, at 11:22 AM, Norman Palardy wrote:
On Oct 13, 2006, at 12:09 PM, Terry Ford wrote:
Or better still, avoid short dates entirely. :)
The only two rules I ever found that worked were
1) use ISO format YYYY-MM-DD hh:mm:ss (or the ever interesting
number form YYYYMMDDhhmmss which works nicely for some databases)
2) use the "word form" of months and a 4 digit year (ie/ April 14
2007 , 14 April 2007, 2007 14 April, 14 2007 April) Regrdless of
how you mess it up you can figure out the date meant
The only problem might be if you use the Parse Date Function in Rb as
"ParseDate honors the Date Format settings of the user's computer". I
don't know any easy way to get that information short of declares to
the OS.
I prefer to determine the input format (with hints to guide the user)
and then get and use the TotalSeconds from my own code. Nothing is
left to chance that way.
Beyond those two it's a crap shoot.
What is 01/02/03 ? (which has occurred)
Wouldn't that be the third day of the second month of the year 1 AD?
Or maybe, on a pre Y2K computer, the 2nd of January 1901? The first
day of February 2003?
I almost think Craps is more predictable if one doesn't stipulate the
entry format in a user friendly way. I know my income tax forms make
that quite clear when it comes to stealing a big chunk of my hard
earned wages. :)
Terry
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
