Problem with dates. -Reply -Reply

[Deskin, Bob]

If you have a relational database, then you can specify an Element in
your dictionary with the same name as the column. If the element is
defined as date, then PowerHouse will treat it as a date. Another option
is to specify DATE as an option on the FIELD statement. This is useful
for items that are sometimes treated as dates and sometimes as numbers.
In QUIZ, if you specify a date format, QUIZ will treat the item as a
date for display.

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: 	Stewart, Mark[SMTP:MStewart@VICTORIA.COM]
> Sent: 	Thursday, June 04, 1998 12:35 PM
> To: 	'Deskin, Bob'; powerh-l@lists.swau.edu
> Subject: 	RE: Problem with dates. -Reply -Reply
> 
> I guess I should explain myself.  Yes the datatype is integer in PHD.
> I am
> used to working with tables VS RMS.  Here they have setup up some
> dates in
> the database as integer.  If you do a quick screen generation the
> dates show
> up as 19,980,101 instead of 1998/01/01.  They don't mirror the
> database in
> the dictionary unfortunately.
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> 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.