Re: Dateadd function error

[Rick_Creel@AONCONS.COM]

Both variables ($sunday    and   $parm-end-dt) need to be explicitly declared as
date.

begin-setup
   declare-variable
      date    $sunday, $parm-end-dt
   end-declare
end-setup






jim nowlin <jim_nowlin@NAVIGATORS.ORG> on 07/02/2001 02:58:04 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  Dateadd function error



Brio product and version number:  SQR V4.3.4
Operating system and version number: True64 (Compaq) 5.0A
Database name and version number: Oracle 7.3.4.0.0

This is the first time I tried to use "dateadd". The code I'm using
follows:

  let $sunday = dateadd($parm-end-dt,'DAY',6)

I get the following error in the sqrlog:

Error on line 118:
   (SQR 4045) Function or operator 'dateadd' requires date argument.

Any ideas on what I'm doing wrong?

If I can get this to work, can I use a negitive number to subtract six
days?

Thanks for the help,
Jim Nowlin
jim_nowlin@navigators.org