SQL command help

[aftab45]

Hello,

I am attempting to add a sql command to my report but I'm having some trouble with the syntax. My current report hardcodes some dates in the where clause, but what I would like to do is use some sql functions to calculate the correct date, as I intend to schedule the report when complete. So for example,

select * from tableA
where start_date_and_time >= (function to get date 30 days ago)

I tried to use datediff but kept getting an error

Failed to open a rowset
Details: 420river]Unexpected extra token: (

I'm running crystal reports 9, sql server 2000.

Thanks in advance.
Aftab.

 

[lbass]

I'm not sure what works for your datasource, but for Oracle, I use:

{fn now()}-30

You can try now() with and without the {fn}. You could also try using "today".

-LB