UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Default Today's Date?    
 
   
gkmros
post Jun 11 2007, 10:42 AM
Post #1

UtterAccess Addict
Posts: 211
From: Hamilton, Ontario



I am sure this is a fairly easy question for most of you, but I have searched through the posts here on UA and I cannot seem to get a clear answer.

I have a data entry form that contains a date field for inputting the date the entry was made. I have a pop-up calendar which is activated on the double click event and the date can be selected from there. However, about 90% of the time the entry date will be today's date.

Is there anyway that I can have today's date automatically stamp itself into this control when starting a new record entry?

Thanks!
Go to the top of the page
 
+
Snapper316
post Jun 11 2007, 10:47 AM
Post #2

UtterAccess Guru
Posts: 566
From: Lakeland, FL



=Now() is todays date with the current system time

=Date() is today's date

and set those under Default value either on table design or on the form
Go to the top of the page
 
+
gkmros
post Jun 11 2007, 11:30 AM
Post #3

UtterAccess Addict
Posts: 211
From: Hamilton, Ontario



Thanks! That worked fine.

I knew someone would have the answer.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 04:30 AM