Hi Albert, Another advantage of the YYYYMMDD format is that it doesn't have to be a date format and so is easy (particularly visually) for sorting as a number. As a number you can also use "zero zero" if a month or day is unknown.
Then you can add in time as HHMMSS and also forget the time format for sorting. And, of course, you can join the two together to get a numeric date and time. So, for the here and now we have: 20050512074815 = 2005/05/12-07:48:15 always going from the largest component to the smallest. And just think of the fun if people around the world chose to use different sequences for hours, minutes & seconds. Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, May 12, 2005 5:22 AM Subject: [RBG7-L] - Re: Date format > The problem we have in Canada is that 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 using dates in MM/DD/YY(YY) > format. The logical, indisputable, you cannot possibly mix up the month and 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 that appreciated it the most were > payroll people who had to enter time cards. With the US standard date format, the DD is in the > middle, requiring multiple keystrokes or mouse clicks to change the date up one day. > > With the UK standard format the DD comes first so [Del][Del]11 will change the day from the 10th > to the 12th, and with the suggested format, the DD is last, making it quite 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 dealt with preferred the day > last. Most of the current users prefer the calendar drop down if they are mouse oriented, the > 2005/06/10 format if keyboard oriented. > > There is a significance to the 2005/06/10 date that I leave to the imagination 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 some Canadiancompanies (in the same > province) and not others, and even in the samecompany some departments do it 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 the month(???) > > 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 does work)or is > > this a boo boo? > > Also, the date/time picker doesn't have a YY/MM/DD or YYYY/MM/DDformat. > > And (sorry) is there a property command to change the picker formaton 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] >
