Close out on the Odd PH VAX Code

[Deskin, Bob]

Mea culpa. I must have been asleep. The version of the DATE function
with the base date WAS only on OpenVMS in Series 7. In Series 8, it's
available everywhere. So those of you who get 8.19 on MPE/iX and 8.13 on
UNIX will also get this "new" feature. I'm not sure if it's documented
as a new feature. I've got to get that Handbook updated one of these
days.

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: 	MattO1@aol.com[SMTP:MattO1@aol.com]
> Sent: 	Friday, August 07, 1998 12:35 PM
> To: 	powerh-l@lists.swau.edu
> Subject: 	Close out on the Odd PH VAX Code
> 
> Hey list world!
> 
> Thanks to all who answered my "odd" question, both to me personally
> and to the
> list.  
> 
> Special thanks to Ken Wong, Kevin Gordon, and Allison Hamilton who all
> filled
> me in on the CMS reference numbers (that was the weird *4D stuff).  
> 
> Also to Arthur Kogan, Dirk Rohde, and Bob Deskin who together helped
> explain
> the odd Date function.  For everyone's edification:
> 
> ITEM T_INV_DATE  = DATE(0,T_DATE)
> 
> This version of the Date function IS legal, but ONLY on OpenVMS.  The
> first
> parameter specifies the number of days (just like everyone else's DATE
> function), but the second value represents the Base Date from which
> the days
> are offset.  If you were using the PowerHouse defaults, it would look
> like
> DATE (num-of-days, 18991231) or 19000101 LOL I don't know which.
> 
> Of course, that means the programmer was calculating the date that is
> zero
> days from T_DATE... So I'm still at a bit of a loss to explain the
> logic of
> the code. But I understand the syntax at least. 8-)
> 
> Thanks again all!
> Matt 8-)
> 
> Matt Ohmes
> Matt.Ohmes@Cognos.Com
> MattO1@AOL.COM (that's "Oh" 1, not "Zero" 1)
> 
> Cognos Corp.
> 909 E. Las Colinas Blvd.
> Suite 1900
> Irving, TX  75039
> (972) 556-1122
> 
> "The views of Matt do not represent the opinions of Cognos in any way.
> In
> fact we refuse to admit he even works for Cognos. Don't trust him and
> never
> loan him money!"
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> 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.