Creating a century window in QUIZ/QT
pickerij@norbord.com
pickerij@norbord.com
Tue, 31 Mar 1998 17:33:07 -0500
Byron Welch asks ...
>We are currently working with a customer who can not at this time move
>from version 7.09 on a HP3000 using MPE\IX 5.5. They would like to
>implement a century window for a defined item with a parm prompt. They
>would also like to use a format of MMDDYY for data entry:
>
>Define TEST date century excluded= parm prompt "Enter Start Date
>(MMDDYY): " format MMDDYY
>
>Define NEW-TEST date century included format MMDDYY =
> ADDCENTURY(TEST2,19) if NEW-TEST > 19101231 else &
> ADDCENTURY(TEST2,20)
>
>The problem with the code above is that you cannot enter 02/29/00. Can
>anyone think of a solution that would allow me to enter data into a date
>field (so I can get default date validation) and still allow a value of
>02/29/00 without going to a four digit entry.
You could set the default century to 20 in the dictionary since that's
what's preventing the netry of 02/29/00 -- Powerhouse applies the
dictionary default century to century excluded dates, in your case 19,
and correctly flags Feb 29 1900 as invalid.
Changing the default century might be a good idea but I wouldn't do it
casually :-)
John Pickering
JWP Systems Inc
Toronto
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.