[sqr-users] Dateadd

["Sumana.Akella" <Sumana.Akella@kiewit.com>]

Thanks

I realized that but I can't declare $Pay_End_DT as a Date variable as
such I had to come up with a work around, something like this....

begin-procedure obtain-max-wrkday-dt
   show 'Procedure obtain-max-wrkday-dt'
     
begin-select
to_char((to_date($pay_end_dt_HH-YYYY-MM-DD ,'YYYY-MM-DD')+14),
'YYYY-MM-DD') &max_wrkday_date
FROM DUAL
end-select

well It did work for me :)


Sumana 


-----Original Message-----
From: sqr-users-bounces+sumana.akella=kiewit.com@sqrug.org
[mailto:sqr-users-bounces+sumana.akella=kiewit.com@sqrug.org] On Behalf
Of Janakiraman, Vijayakumar
Sent: Wednesday, October 18, 2006 9:58 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Temp Table Error

The $Pay_End_DT has to be a date variable. Declare it as a date variable
in Begin-Setup section. 


Thanks,
Vijayakumar.J


-----Original Message-----
From: sqr-users-bounces+vijayakumar.janakiraman=cingular.com@sqrug.org
[mailto:sqr-users-bounces+vijayakumar.janakiraman=cingular.com@sqrug.org
] On Behalf Of Sumana.Akella
Sent: Wednesday, October 18, 2006 9:55 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Temp Table Error

(SQR 4045) Function or operator 'dateadd' requires date argument.

LET $max_wrkday_date = dateadd($PAY_END_DT, 'day', 14)

Can some one please let me know why the dateaddfunction is throwing and
error

Thanks
Sumana
 


_______________________________________________
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

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