Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show dates the past 2 year to now 1

Status
Not open for further replies.
din2005

din2005

Programmer
Mar 22, 2005
162
GB
Hi all am sure this might be a simple one... but am abit slow today how would i show the dates of all patients who have been treated in the past two years to now!

do u know what the criteria would be?

many thanks
 
Sort by date Sort by votes
WHERE DateTreatedField > DateSerial(Year(Date())-2, Month(Date()),Day(Date()))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
729
dhookom
dhookom
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
7
Views
244
Chriss Miller
C
C
  • Question
Query expression negative to a 0
Replies
6
Views
398
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
602
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top