Start query from 01-01-year(date()

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

How can a i use 01-01-year(date()) in my query for date calculation.

e.g. >= 01-01-year(date()) and <=DateField

Tried "01-01-"&year(date()) but that doesn't work....


Thanx for any response.

Regards,
Harmannus
 
Harmannus said:
Hallo,

How can a i use 01-01-year(date()) in my query for date calculation.

e.g. >= 01-01-year(date()) and <=DateField

Tried "01-01-"&year(date()) but that doesn't work....
Click to expand...

DateSerial(Year(Date()), 1, 1)
 
Back
Top