Default date to 1st day of the Month

  • Thread starter sebastian stephenson
  • Start date
S

sebastian stephenson

Hello All.

I would like a text box on a form to display the 1st day of the relevent
month when the form is loaded.

I know how to get the current date i.e, Date() and how to DateAdd and
subtract, but not how to load the 1st day of each month.

Any ideas.
 
F

fredg

Hello All.

I would like a text box on a form to display the 1st day of the relevent
month when the form is loaded.

I know how to get the current date i.e, Date() and how to DateAdd and
subtract, but not how to load the 1st day of each month.

Any ideas.
Click to expand...

Which month is the relevant month?
The current month? The next month?

The current month:
=DateSerial(Year(Date()),Month(Date()),1)

The next month:
=DateSerial(Year(Date()),Month(Date())+1,0)
 
F

fredg

Which month is the relevant month?
The current month? The next month?

The current month:
=DateSerial(Year(Date()),Month(Date()),1)

The next month:
=DateSerial(Year(Date()),Month(Date())+1,0)
Click to expand...

Whoops,

regarding =DateSerial(Year(Date()),Month(Date())+1,0)
I inadvertently gave you the last day of the current month.
It should have been:
=DateSerial(Year(Date()),Month(Date())+1,1)
 
T

Tim Ferguson

=?Utf-8?B?c2ViYXN0aWFuIHN0ZXBoZW5zb24=?=
I would like a text box on a form to display the 1st day of the relevent
month when the form is loaded.
Click to expand...

firstOfMonth = CDate(someDate - Day(someDate) + 1)


Hope that helps


Tim F
 
Top