dateadd not working

[souladventurer]

Hello,

I have the following SQL in the where statement, I do not receive an error but the query does not return any data.

DATABASE.[DATE BILLED SS] BETWEEN DATEADD("d",-90,DATE()) AND DATEADD("d",-300,DATE())

any suggestions on how to make this work?

Thanks!

 

[scriverb]

This may be very simple. I think you have flip flopped the low and high date parameters. Try this:

DATABASE.[DATE BILLED SS] BETWEEN DATEADD("d",-300,DATE()) and DATEADD("d",-90,DATE())

You see the first DateAdd should be the LOW date value and the second DateAdd should be the HIGH date value.



Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???