Auto Date

[Guest]

This is a fairly basic question.
I currently have a date box which enables the user to enter the date. Is
there any possibility of the box to automatically display todays date, and
save details with todays date. (ie, so if I saved details under todays date,
and decided to retreive at a later date, the date i saved it under would
appear with all the details)

 

[Rick B]

Just use the "default" property in your form. Put...

= Date()

 

[Guest]

Yes I have already done this, however it displays __/__/___ on the date box.
I need it to display todays date automatically.... Is there something I am
doing wrong?

Thanks!

 

[Rick B]

If you have put the statement below in the 'default' then it will display
today's date.

What you are describing sounds like you have formatted the field as a date
(which does need to be done) but you have not made an entry in the default
property. Entering =date() in the default will cause the current
date to pop into that field when you hit a new blank record in your form.

Note: This is in a FORM not in the TABLE.


Rick B

 

[Guest]

Thankyou! Now working...!!

If you have put the statement below in the 'default' then it will display
today's date.

What you are describing sounds like you have formatted the field as a date
(which does need to be done) but you have not made an entry in the default
property. Entering =date() in the default will cause the current
date to pop into that field when you hit a new blank record in your form.

Note: This is in a FORM not in the TABLE.


Rick B