Developer Forum

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

Calendar year?

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