date default issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnE - 04 Jun 2007 22:09 GMT

I have a form that has 2 fields on it; one for begin date and the other for
end date. The users want both of these fields to default to the first day
and last day of the previous month. (ex: we are in June so the defaults
would be 5/1/2007 and 5/31/2007). I am at a lost on doing this and ask for
help from the news group.
Thanks for any help given.
... John

Reply to this Message

Ofer Cohen - 04 Jun 2007 22:23 GMT

You can write it either in the form text box or in the table fields, in the
default value

In the Start Date
DateSerial(Year(DateSerial(Year(Date()), Month(Date()),
0)),Month(DateSerial(Year(Date()), Month(Date()), 0)),1)

In the End Date
DateSerial(Year(Date()),Month(Date()),0)

Signature

Good Luck
BS"D

> I have a form that has 2 fields on it; one for begin date and the other for
> end date. The users want both of these fields to default to the first day
[quoted text clipped - 3 lines]
> Thanks for any help given.
> ... John

Reply to this Message

JohnE - 04 Jun 2007 22:34 GMT

Perfect!
Thanks.

> You can write it either in the form text box or in the table fields, in the
> default value
[quoted text clipped - 13 lines]
> > Thanks for any help given.
> > ... John

Reply to this Message

Rick Brandt - 04 Jun 2007 22:44 GMT

> You can write it either in the form text box or in the table fields,
> in the default value
>
> In the Start Date
> DateSerial(Year(DateSerial(Year(Date()), Month(Date()),
> 0)),Month(DateSerial(Year(Date()), Month(Date()), 0)),1)

Why all of that when...

DateSerial(Year(Date()), Month(Date())-1,1)

...gives the same result?

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Ofer Cohen - 04 Jun 2007 22:58 GMT

You right Rick

For some reasone I thought that I'll have a problem with January, you method
is correct

Thank you

Signature

Good Luck
BS"D

> > You can write it either in the form text box or in the table fields,
> > in the default value
[quoted text clipped - 8 lines]
>
> ....gives the same result?

Reply to this Message

Rick Brandt - 04 Jun 2007 22:23 GMT

> I have a form that has 2 fields on it; one for begin date and the
> other for end date. The users want both of these fields to default
[quoted text clipped - 3 lines]
> Thanks for any help given.
> ... John

Default Values of...

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message