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.