G Guest Dec 10, 2003 #1 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.
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.
W Wayne Morgan Dec 10, 2003 #2 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 Click to expand... 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 Click to expand... previous month from today's date. Today is 10-12-03. We want the default value as 30-11-03. Please help.
