first of current month as default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I manage an apartment building and have set up an Access 2003 database to
help with the paperwork.

I'm trying to automate some of the steps in generating a rent receipt so my
75 year old boss will be comfortable using the computer.

I'm having trouble figuring out how to set the default vlaue of the "apply
rent to" date field to be the first day of the current month. I have tired
using datepart function, but cannot seem to get the syntax correct. Any
suggestions?

Thanks!

Jim
 
"thestrangerurmotherwarneduabout"
Hi,

I manage an apartment building and have set up an Access 2003 database to
help with the paperwork.

I'm trying to automate some of the steps in generating a rent receipt so my
75 year old boss will be comfortable using the computer.

I'm having trouble figuring out how to set the default vlaue of the "apply
rent to" date field to be the first day of the current month. I have tired
using datepart function, but cannot seem to get the syntax correct. Any
suggestions?
Click to expand...

DateSerial(Year(Date), Month(Date), 1)
 
You must log in or register to reply here.

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

vlookup with multiple values 3
Excel Message box with days of month & date. 1
DatePart in default value 3
Generate Date for the first of the following month 0
List of dates 4
Combining a 3-Step Formula into One Formula 4
Access 2003 - Setting default value of a text box 5
Formulas - Ugh! 5

Back
Top