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)
 
Back
Top