01-01-CurrentYear

[Pedro Magueija]

Is there a function that returns the value "01-01-CurrentYear"??
I need this value because I want my query to return all records between the begining of the year and current date. I already did this but I had to insert <Between #01-01-2004# And Date()> in the criteria of the query. What I want is to have the initial date to change years automatically.
Thanks in advance...

 

[ghudson]

Here is one way to do it. I am using a message box just to show you how simple it is to return the current year from the PC's system clock.

MsgBox "01/01/" & Format(Date, "yyyy")

 

[AN60]

Try this in the criteria;

Between DateSerial (year(date()),1,1) AND Date()

 

[Pedro Magueija]

Try this in the criteria;

Between DateSerial (year(date()),1,1) AND Date()

Thanks, worked out perfect.....