Re: Dateadd function error

[Carlton Conley <cconley@CDG-INC.COM>]

in the begin-setup section of the SQR you must declare the $ variable as a
date, by default it is treated as a string and while will insert if in the
proper format or be treated as a date inside a query, to SQR it is not a
date

so

begin-setup

        declare-variable
                date $sunday
        end-declare

end-setup


This should solve your problem

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of jim nowlin
Sent: Monday, July 02, 2001 11:58 AM
To: SQR-USERS@list.iex.net
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