Validation part of a date in a table

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

Guest

Is there anyway that I can validate that the day part of an expression is the
last day of that month? The user can choose any month and year, but I want
the day to always be the last day of that month. Any help is appreciated.
 
Is there anyway that I can validate that the day part of an expression is the
last day of that month? The user can choose any month and year, but I want
the day to always be the last day of that month. Any help is appreciated.
Click to expand...

To determine the last day of any month:

=DateSerial([What Year],[What Month]+1,0)

i.e. DateSerial(2006,7+1,0) = 7/31/2006
 
Thanks for the quick reply, I will try this.

fredg said:
Is there anyway that I can validate that the day part of an expression is the
last day of that month? The user can choose any month and year, but I want
the day to always be the last day of that month. Any help is appreciated.
Click to expand...

To determine the last day of any month:

=DateSerial([What Year],[What Month]+1,0)

i.e. DateSerial(2006,7+1,0) = 7/31/2006
Click to expand...
 
Back
Top