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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
Converted from LINUX time ok, but having issues with the between date. 4
Running Balance (Debit and Credit) in Access 2007 4
Return multiple records from a single entry. 2
multiple records from one 1
Looking up across date ranges in Access 2
extract 3 numbers from a string 0
Counts number of entries per day in query 4

Back
Top