If statement need help

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a query that has an approval date in it. i want to
pull all loans where the approval date is greater than
10/1/03 i dont want to go in and change my query every
time for example next month i'll put greater than
11/1/03 i always want that same buffer is there a
way i can do this with the datediff function?
 
Could you make a parameter? I'm a little new to this, but
something like =>[Enter date]. Would that work?
 
Try using the DateSerial function. It should work for you.


SELECT Fields
FROM TableName
WHERE ApprovalDate >= DateSerial(Year(Date()), Month(Date())-2,1)
 
Back
Top