Set Datefield to first of month (default)

[pookie62]

Hi,
I want a datefield defaults value to be the first of the current month.
DateSerial(Year(date), Month(date), 1) should do the trick, but whatever I try, it won't work...don't know where to set this.
Tried the field props in table, props on Form, no luck so far..
Anyone ideas ?
Thanks

 

[stopher]

Try:
=DateSerial(Year(Date()),Month(Date()),1)

Stopher

 

[pookie62]

Hi Stopher,
Tried that one too, no luck
What is the place to set this ??
Maybe I set it on the wrong place..

 

[MStef]

Look at "DemoFirstOfMonthA2000".
Look at Default Value properties.
It is th text field now, adapt it as you
need, (depending on your date format).
In Format properties put SHORT DATE, or
what you want.