year of date field is same as year of today

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

 

[Tom Lake]

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?

Create a calculated field in your query:

Yr: Year([Start Date])

and make the Criteria for Yr be:

=Year(Date())

Tom Lake

 

[peregenem]

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

Calendar year?

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