Default Date Value

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

Guest

How to make the default value of a text box set as the last day of the previous month from today's date. Today is 10-12-03. We want the default value as 30-11-03. Please help.
 
Set the Default Value to

DateSerial(Year(Date()),Month(Date()),0)

The zero is really 1-1, the first day of this month minus one.

--
Wayne Morgan
Microsoft Access MVP


JB said:
How to make the default value of a text box set as the last day of the
previous month from today's date. Today is 10-12-03. We want the default
value as 30-11-03. Please help.
 
Back
Top