Day of Week Function

EDISR@detroitedison.com EDISR@detroitedison.com
24 Jul 98 10:17:39 -0400


Or ... why not try a CASE statement, assuming you are not in QDESIGN! 
 
E.g.  
 
DEFINE d_day_num = MOD(DAYS(anydate),7) 
DEFINE d_day_of_week CHAR*9 = CASE OF d_day_num & 
  WHEN 0 THEN "Sunday" & 
  WHEN 1 THEN "Monday" & 
  etc. 
 
BTW, why CAN'T I use the CASE statement in QDESIGN?  I understand it is much 
more efficient processing wise than an IF,THEN,ELSE. 
 
Of course this could lead into one of my pet grips - the inconsistency of 
syntax between QDESIGN,QUIZ and QTP.  I guess it separates the 'men' from
the 
'boys' ;) 
 
 
Robert Edis (Blue) 
Technical Consultant 
Michigan, USA 
(VAX/VMS, ORACLE Rdb, PowerHouse 4GL)
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.