Date Help

[tmcrouse]

I have a query that I am trying to construct and a bit confused on how I should construct the date. I have the following columns with data in my table:

sysid
dischargedate
firstservicedate
proc



I want to have the query to compare the dischargedate and firstservicedate and return any sysid where the firstservicedate is 30days greater than the dischargedate

so i would think putting something like [dischargedate]>31[firstservicedate] in the firsetservicedate area??? not sure. really confused on this one.

or how about [dischargedate] >=[firstservicedate]>31

[pbaldy]

In SQL view try

...WHERE firstservicedate - dischargedate > 30

You could also use the DateDiff() function in a new field and put your criteria there (>30)