Validation part of a date in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GeorgieGirl - 22 Jul 2006 21:31 GMT

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.

Reply to this Message

fredg - 22 Jul 2006 22:11 GMT

> 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.

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

GeorgieGirl - 23 Jul 2006 01:28 GMT

Thanks for the quick reply, I will try this.

> > 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
[quoted text clipped - 5 lines]
>
> i.e. DateSerial(2006,7+1,0) = 7/31/2006

Reply to this Message