Albert I have a minor request, cant you submit your excellent summary of the benefits of YYYY/MM/dd to, what do I know, maybe AMERICAN NATIONAL STANDARD INSTITUTION (ANSI) for an official approval of your suggestions?
Gunnar Ekblad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: den 12 maj 2005 18:32 To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Date format Close, but not quite. It is not a decade, but equally significant. At least to me. --- Dennis Fleming <[EMAIL PROTECTED]> wrote: --------------------------------- Thanks Albert, Takes me back many years when all dates/times were converted to aperpetual second clock which I think started ticking at 1960/01/01 (?).(used for Airline, Rental Car, etc.) Have you used the popup calendar for the YYYYMMDD format? I'm guessing 2005/06/10 may be tied into an even number of decades thatsomeone has been on the planet. ... At 12:22 AM 5/12/2005, you wrote: The problem we have in Canada isthat officially we should be using DD/MM/YY(YY), but so many of us work with companies with US roots and/or divisions, and end up usingdates in MM/DD/YY(YY) format. The logical, indisputable, you cannot possibly mix up the monthand day is to use the YY(YY)/MM/DD format. If you use all four digits of the year it becomes obvious what is where.06/10/05 is ambiguous, 2005/06/10 is not. Users get used to it quite quickly. The users thatappreciated it the most were payroll people who had to enter time cards. With the US standard dateformat, the DD is in the middle, requiring multiple keystrokes or mouse clicks to change the dateup one day. With the UK standard format the DD comes first so [Del][Del]11 willchange the day from the 10th to the 12th, and with the suggested format, the DD is last, making itquite easy to change the date from 2005/06/10 to 2005/06/11 using [End][BackSpace]1. 2005/05/19 to 2005/05/20 needs two backspaces. The payroll users I dealtwith preferred the day last. Most of the current users prefer the calendar drop down if they aremouse oriented, the 2005/06/10 format if keyboard oriented. There is a significance to the 2005/06/10 date that I leave to theimagination of those who know me for a (far too high) number of years. --- Dennis Fleming <[EMAIL PROTECTED]> wrote: --------------------------------- Albert, I was surprised that the YYYY/MM/DD format is used by someCanadiancompanies (in the same province) and not others, and even in the samecompany some departments doit differently. I guess a four digit year isa must. Is the year first considered the"metric" format? When I put the above in the date picker format I get a zero for themonth(???) Dennis ***** At 04:14 PM 5/11/2005, you wrote: Dennis, the date picker formatis a PROPERTY command PROPERTY DatePickerID FORMAT 'FORMAT' One format example given is 'Today''s date:' MMM dd, yyyy I suspect some work with the quotes would be advisable LOL. --- Dennis Fleming <[EMAIL PROTECTED]> wrote: > (RB7- 7.1.81.30505) > > I think I know the suggested fix for my problem, but... > > If I have the date format as: MM/DD/YY > all my dates work fine on my forms. > > But, at a customer who has: YY/MM/DD > I get "invalid date" for any date change. > > Should I change all my forms to a four digit year (which doeswork)or is > this a boo boo? > Also, the date/time picker doesn't have a YY/MM/DD orYYYY/MM/DDformat. > And (sorry) is there a property command to change the pickerformaton the fly? > > Thanks, > > Dennis > ***** > Dennis Fleming > IISCO >http://www.TheBestCMMS.com > Phone: 570 775-7593 > Mobile: 570 351-5290 > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED] Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Mobile: 570 351-5290 Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED] --- RBG7-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================ Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Mobile: 570 351-5290 Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
