Stumped on date

[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.

[tmcrouse]

I was thinking about putting in the firstservicedate column

=datediff([dischargedate],[firstservicedate])+30

[tmcrouse]

or maybe
[dischargedate]>=[firstservicedate]+30