That's because Dave was doing the expression in the Immediate Window.

To use it in a query, it would look like:

Expr1: DateSerial(Year(Date()),Month(Date())-1,1)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com



"Amanda" wrote in message
...
Thank you for your response! However, if I input

?dateserial(year(date),month(date)-1,1)

Access says there's an invalid operator in my expression. If I take the
question mark away, Access automatically updates the line to:

DateSerial(Year("Date"),Month("Date")-1,1)

And my text box gives me an #Error value. I've tried taking the quotes
away, but Access keeps putting 'em back.

"Klatuu" wrote:

?dateserial(year(date),month(date)-1,1)
9/1/2009
?dateserial(year(date), month(date)+1,0)
10/31/2009
--
Dave Hargis, Microsoft Access MVP


"Amanda" wrote:

I have 2 text boxes in a form that default to two set dates. I'd like
to
update the form so that txtStartDate is the first date of last month
and
txtEndDate is the last date of this month. For example, if I were to
pull
the form up today, I'd like txtStateDate's default to be 9/1/09 and
txtEndDate's default to be 10/31/09. If I pull it up the form in
November,
txtStartDate should be 10/1/09 and txtEndDate is 11/31/09.

Both text boxes are unbound. Any suggestions?