Takes me back many years when all dates/times were converted to a perpetual 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 that someone has been on the planet.
...
At 12:22 AM 5/12/2005, you wrote:
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]
--- 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
Phone: 570 775-7593
Mobile: 570 351-5290
