year of date field is same as year of today

year of date field is same as year of today

Post by RGF0YWJhc2 » Fri, 29 Jul 2005 19:04:01


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?
 
 
 

year of date field is same as year of today

Post by Tom Lak » Fri, 29 Jul 2005 19:16:02


Create a calculated field in your query:

Yr: Year([Start Date])

and make the Criteria for Yr be:

=Year(Date())

Tom Lake

 
 
 

year of date field is same as year of today

Post by peregene » Fri, 29 Jul 2005 20:52:31


Calendar year?

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