Current Year criteria

  • Thread starter Thread starter Piers 2k
  • Start date Start date
P

Piers 2k

Hi folks,

Am trying to create a query to retrieve records using the current year from
a date field. I need to have it pick up the current year from the computer.
Something to do with a Between and Date()

Just to make things worse, I have a start date and an end date field, but
hopefully once I get the first criteria I can adapt it.

Any help folks?

Piers
 
Hi folks,

Am trying to create a query to retrieve records using the current year from
a date field. I need to have it pick up the current year from the computer.
Something to do with a Between and Date()

Just to make things worse, I have a start date and an end date field, but
hopefully once I get the first criteria I can adapt it.

Any help folks?

Piers
Click to expand...

Where Year([StartDate] = Year(Date())
or...
Where YourTable.[StartDate] between DateSerial(Year(Date()),1,1) and
Date()
 
Back
Top