By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,589 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

access date function question

P: n/a
How can I get the current date to appear in a form - but also be able
to change that date permanantly

example

i have a start date and and end date for my clients
these two date calculate in months how long a client has been there

i would like the end date to automatically default to the
current(present day) date ---but i would like to also have the means to
change the date and keep it permanant for history purposes

thanks

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"hyde" <hy*****@comcast.net> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
How can I get the current date to appear in a form - but also be able
to change that date permanantly

Set "Date()" to be the default value of the control/field.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #2

P: n/a
"hyde" <hy*****@comcast.net> wrote in
news:11**********************@o13g2000cwo.googlegr oups.com:
How can I get the current date to appear in a form - but also
be able to change that date permanantly

example

i have a start date and and end date for my clients
these two date calculate in months how long a client has been
there

i would like the end date to automatically default to the
current(present day) date ---but i would like to also have the
means to change the date and keep it permanant for history
purposes

thanks

You should not do exactly what you want. Instead, in the table
and on the form, you can have the end date be blank(null) for
the end date for customers who have not ended. In the
calculation for the period, you can use the nz() function to
choose the table date if it exists, the system date() if it does
not.

The control source for the period is
=DateDiff("m",startdate,NZ(EndDate,Date()))

This also gives a better indication of active customers, because
putting the date in the enddate for all customers means that the
user needs to evaluate the actual date to see if it's today,
versus just seeing that it's empty.

--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.