Static Dates in Forms?

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

Guest

This is probably very simple but I can't figure out how to add the current
date to a form and NOT have it updated by the computers internal clock and
calendar. Is it possible to create a formula that populates the current date
and time in their fields and for those dates and times to be permanent?
 
In the default property of the field in the form write
=Now()
that will return the current date and time

=date()
Will return the current date

=Time
Will return the current time
====================================
Every time you add a new record, the field will be filled with the default
you assign to it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top