Default Date Value

J

JB

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2010: trouble saving font/size 9
Macro for Dates 5
time_report_date-wise_employee-wise 6
Linking Child Timelines to Multiple Parents 0
Reverse Index Match 2
Returning a Date with Multiple Criteria Lookup Values 0
How do I set focus (and select text) on a text box on a modeless userform? 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top