Creating a century window in QUIZ/QTP for PROMPT variables.

[Deskin, Bob]

Here's the response I sent originally (but it didn't get to the entire
list).

Change your default century from 19 to 20. That's the only way that
PowerHouse will allow a century excluded date value of 000229. However this
will mean that PowerHouse assumes that ALL century excluded dates are in the
21st century. It also means that 20 is added to all century excluded or 0
century dates and date expressions when being processed by the date
functions. Need I go on.

Look for an article on the effects of CENTURY INCLUDED in the next
SupportLink.

And by the way, PowerHouse 7.09 is NOT year 2000 compliant. It will not
retrieve the system date correctly on Feb 29, 2000.

Bob Deskin              
Senior Product Advisor  bob.deskin@cognos.com
Cognos Inc.             (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

> ----------
> From: 	David Heasman[SMTP:David_Heasman@Thru-Transport.com]
> Sent: 	April 1, 1998 4:17 AM
> To: 	powerh-l@lists.swau.edu
> Subject: 	Re: Creating a century window in QUIZ/QTP for PROMPT
> variables.
> 
> 
> 
> 
> 
> 
> 
> 
> Please respond to bewelch@bellatlantic.net
> 
> > 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.
> Byron Welch
> 
>  Set the default century to "20"??
> 
> 
> 
> 
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 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.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.