RE: [sqr-users] DATEADD function

["Bob Helm" <Bob.Helm@mediware.com>]

I think you might have to declare $anal_due as a date variable. Perhaps that 
could be it.


-----Original Message-----
From: skirklin@stl-inc.com [mailto:skirklin@stl-inc.com]
Sent: Monday, September 08, 2003 10:55 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] DATEADD function



Hello fellow SQR users,

Here is a portion of some code that I'm using:

select distinct
q.queue () on-break print=never level=1 before=bef-q after=aft-q
qtf.fraction &fraction
q.name &qname
s.due_date &duedate
pj.project_seq  () on-break print=never level=2 before=bef-wo after=aft-wo
pf.cust_id &customer
pf.reqnbr &profile
pf.cs_contact &csc
pac.acode () on-break print=never level=3 before=bef-acode after=aft-acode
ps.hsn &hsn
nvl(pac.charge,-1) &price
price.charge &listprice
  let $anal_due = dateadd(&duedate, 'day', -2) 
from yada yada yada...

I'm trying to calculate a date 2 days earlier than the s.due_date and this
is why I'm using the DATEADD function.

In some cases this is working but in others it is not. The field s.due_date
is of the format 19-SEP-03 when it comes from the database.

Can someone suggest a better way of doing this?

Thanks much,

Sherri Kirklin
Sherri Kirklin
Analyst/Programmer
STL-Austin
Ph: (512) 310-5286
Fax: (512) 244-0160
skirklin@stl-inc.com




Confidentiality Notice: The information contained in this message is
intended only for the use of the addressee, and may be confidential
and/or privileged. If the reader of this message is not the intended
recipient, or the employee or agent responsible to deliver it to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify the
sender immediately.

_______________________________________________
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