year of date field is same as year of today

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to write in my query to bring me up records where the year of the
student start date field is the same as the year of today

how can this be done?
 
Database User said:
i want to write in my query to bring me up records where the year of the
student start date field is the same as the year of today

how can this be done?
Click to expand...

Create a calculated field in your query:

Yr: Year([Start Date])

and make the Criteria for Yr be:

=Year(Date())

Tom Lake
 
Database said:
i want to write in my query to bring me up records where the year of the
student start date field is the same as the year of today
Click to expand...

Calendar year?

WHERE start_date
BETWEEN DATESERIAL(YEAR(DATE()), 1, 1)
AND DATESERIAL(YEAR(DATE()), 12, 31)
 
Back
Top