Selection of last day of the month

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

DontKnow

Hi Guys,

I need to be able to select the lasst day of each month in a text box eg. as
we are currently in the Month of August I need to be able to have the 31 Aug
09 to be displayed in a text box and so on for every month of the year!

is there any code that is already does this??

Please help me ,

cheers,
 
Hi Guys,

I need to be able to select the lasst day of each month in a text box
eg. as we are currently in the Month of August I need to be able to have
the 31 Aug 09 to be displayed in a text box and so on for every month of
the year!

is there any code that is already does this??
Click to expand...

Do you want to display it with an expression or store it as a default
value? Either would use the DateSerial() function.

=DateSerial(Year(Date()), Month(Date()) + 1, 0)

Explanation: The zeroth of a month is the last day of the previous
month. So you go one month past this month and get the zeroth day of
that. This works at year-end wrap-around and with leap years.
 
Bloody beautiful mate!!

Rick Brandt said:
Do you want to display it with an expression or store it as a default
value? Either would use the DateSerial() function.

=DateSerial(Year(Date()), Month(Date()) + 1, 0)

Explanation: The zeroth of a month is the last day of the previous
month. So you go one month past this month and get the zeroth day of
that. This works at year-end wrap-around and with leap years.
Click to expand...
 
Back
Top