RE: [sqr-users] RE: DATEADD function

["Sengupta, Rajib (CAG-CC-Contractor)" <Rajib.Sengupta@conagrafoods.com>]

I think it is the CAPs- 
try it  let $anal_due = dateadd(&duedate, 'DAY', -2)  
this might not be the case- just give a try

Rajib Sengupta
Systems Analyst and Team Lead
Peoplesoft Financial Consultant
Conagra Business Systems
Phone: 402-595-5749


-----Original Message-----
From: skirklin@stl-inc.com [mailto:skirklin@stl-inc.com]
Sent: Tuesday, September 09, 2003 5:58 PM
To: skirklin@stl-inc.com; sqr-users@sqrug.org
Subject: [sqr-users] RE: DATEADD function



I received two responses for this but neither worked. One was to declare the
variable $anal_due as a date variable. The other was 

"Why not just add to the SQL 
s.due_date - 2 $anal_due"

Does anyone have any other suggestions?

Thanks again,

Sherri


>  -----Original Message-----
> From:         Kirklin, Sherri  
> Sent: Monday, September 08, 2003 10:55 AM
> To:   'sqr-users@sqrug.org'
> Subject:      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