default date = 01/01/this year

D

Dave

Access 2003
on load event of a form
unbound text box

trying to get it to display the first day of the current year.

Here is what I have tried:

txtStartDate = "01/01/ " & " year(date)"

as usual I am betting I have "quoits" or "&" issues

Thanks in advance,

dave
 
R

Rick Brandt

Dave said:
Access 2003
on load event of a form
unbound text box

trying to get it to display the first day of the current year.

Here is what I have tried:

txtStartDate = "01/01/ " & " year(date)"

as usual I am betting I have "quoits" or "&" issues
Click to expand...

=DateSerial(Year(Date()), 1, 1)
 
J

J_Goddard via AccessMonster.com

Hi -

Take the Year(date) out of the quotes:

txtStartDate = "01/01/ " & year(date)


John
 

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

VBA code to call first date of the year and last date of the year 2
Default to 01/01/ of this year 4
date corruption? 00/01/1900 2
Pass date from one form to another form in MS Access 1
Current year date 2
Sum of Numbers of a Rolling 6 month Period range 0
01/01/YY Date problem 1
how do I change date autocomplete in a form? 0

Top