Problem with dates. -Reply

[Deskin, Bob]

The best way to check the value of a date is to use a DEFINE to equate
it to a numeric item and then display the numeric with 8 digits. This
way you don't get any interferance from the default century or the date
format. 

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: 	COLIN GLASS[SMTP:cglass@mlcc.mb.ca]
> Sent: 	Thursday, June 04, 1998 11:22 AM
> To: 	Bob.Deskin@Cognos.COM; powerh-l@lists.swau.edu
> Cc: 	cgingera@mlcc.mb.ca; kbraun@mlcc.mb.ca
> Subject: 	RE: Problem with dates. -Reply
> 
> I get this value when I do an ad hoc Quiz on the file.  What I failed
> to
> mention is when I do an ad hoc Quick screen, the last two digits of
> the date
> are truncated.
> 
> >>> "Deskin, Bob" <Bob.Deskin@Cognos.COM> 06/04/98 08:19am >>>
> When you say ######## exactly what do you mean. Is this a display
> value
> or the actual value on file? How did you determine the value? 
> 
> 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: 	COLIN GLASS[SMTP:cglass@mlcc.mb.ca]
> > Sent: 	Thursday, June 04, 1998 11:14 AM
> > To: 	powerh-l@lists.swau.edu
> > Cc: 	cgingera@mlcc.mb.ca; kbraun@mlcc.mb.ca
> > Subject: 	Problem with dates.
> > 
> > We are running PowerHouse 7.29 on the MPE/iX operating system
> > (HP3000).  We converted this system to be year 2000 compliant.  We
> > have
> > two identical files, one with current info and one with historical
> > info.  A
> > date variable is part of the key for each file.
> > 
> > When running a QTP to transfer the information from the current file
> > to
> > the history file, the date on the history file becomes ########.
> The
> > date is
> > OK on the current file though.
> > 
> > We have checked the dictionary to ensure that the field is a size 8,
> > and it is. 
> > Checked the QTP when it was recompiled with the dictionary changes
> for
> > Y2K, and there were no errors.
> > 
> > My question is why this is occurring and how can we fix it?
> > 
> > Thanks
> > 
> > Colin Glass
> > Manitoba Liquor Control Commission
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> > = = =
> > 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.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.