current year in a query

D

Database User

I need a query that selects anyone who has a date which the date is in this
year

plus all people whos date is last year

how do i do this
 
O

Ofer

To get the current year you can use this
Select * From TableName Where Year(DateField) = Year(Date())

To get the Prev year you can use this
Select * From TableName Where Year(DateField) = Year(Date()) - 1

To get both

Select * From TableName Where Year(DateField) = Year(Date()) Or
Year(DateField) = Year(Date()) - 1
 
R

Rick Brandt

Database User said:
I need a query that selects anyone who has a date which the date is in this
year

plus all people whos date is last year

how do i do this
Click to expand...

SELECT * FROM TableName
WHERE DateField
BETWEEN DateSerial(Year(Date())-1, 1, 1)
AND DateSerial(Year(Date()), 12, 31)
 
J

John Spencer

The criteria would probably be
Field: YourDateField
Criteria: Between DateSerial(Year(Date()) -1,1,1) and
DateSerial(Year(Date()),12,31)

That should return all records where YourDateField is between the Jan 1 of
the year prior to the current year (Jan 1, 2004) and the end of the current
year (Dec 31, 2005). On January 1, 2006 this will criteria will give you
all records from Jan 1, 2005 to Dec 31, 2006.

If that is not what you want, post back with an expanded explanation of what
you do want.
 
Top