Day of Week

[Penney, John]

Christina and All:

Must be my incrementing years, but now remember the syntax. A Big Thanks to
you all who replied!

Have a great weekend!

JP in CA (no cell)

-----Original Message-----
From: Hasse, Christina [mailto:Christina.Hasse@COGNOS.com]
Sent: Friday, June 04, 2004 10:51 AM
To: Penney, John
Subject: RE: Day of Week


Hi John,

It is:

define day-no num*1 = mod(days(sysdate),7)
define day-of-week char*10 = case of day-no &
 when 0 then "Sunday" &
 when 1 then "Monday" & 
 when 2 then "Tuesday" & 
 when 3 then "Wednesday" & 
 when 4 then "Thursday" & 
 when 5 then "Friday" & 
 when 6 then "Saturday"

Regards,

Christina Hasse
ADT N.A. Technical Manager
COGNOS CORPORATION
425 North Martingale Road, Suite 600
Schaumburg, IL  60173
christina.hasse@cognos.com

Office: 847 - 285 - 2905
Cell: 847 - 269 - 1909
Fax: 847 - 240 - 0252

http://powerhouse.cognos.com



-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]
Sent: Friday, June 04, 2004 12:36 PM
To: 'powerh-l@lists.sowder.com'; HP3000-L@RAVEN.UTC.EDU
Subject: Day of Week


Gentle Listers:

Pray tell, how does one determine the day-of-week it is? I vaguely recall
some kind of Powerhouse or HP function like dayofweek = day(20040604)
returning 5=Friday?

Or was that in another incarnation? 8=)

Many thanks for your input.

Happy Friday in any event!

John M Penney
DDPS 
California Department of Corrections
1920 Alabama Ave.
Rancho Cordova, CA 
(916)358-2247
(916)358-2322 Fax
(360)789-8159 Cellular



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber. 
  
       This message may contain privileged and/or confidential information.
If you have received this e-mail in error or are not the intended recipient,
you may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.