RE: [sqr-users] How can I get day of the week from a (ccyymmdd) date?

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

Make sure the value of $mydate is formated correctly.  It probably needs to
be declared as a date variable.  Then try:

 let $dayofweek = edit($mydate, 'DAY')

-----Original Message-----
From: Hale, Keith [mailto:keith.hale@impactinnovations.com]
Sent: Wednesday, August 13, 2003 11:12 AM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] How can I get day of the week from a (ccyymmdd)
date?


Hi,

I've tried: Let $DayofWeek = strtodate($mydate, 'DAY') and get an error
message, "(SQR 1919) Invalid day of week."  I'm using SQR version 4.3.4 (I
believe) and an Oracle 8i database.  And I'm running on a AIX v4 box.

Thanks,
Keith

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users