How do I get the current time to post to an access database field using FrontPage 2003 Database results wizard?

I have a sign in/out intranet that my client wants to use to track where employees are. One of the fields is Time. When a user edits his information I need the current time to be posted into the database so that when other users are looking for that person, the database results table will have the Time that the record was updated.
mstumpoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hieloCommented:
mstumpo, the best apprach for this is to use to Define field in the database whose data type is Date/Time and set its the default to Now(). That way every time you insert a new record, it will automatically get the current time stamp. Ex: If you had the following table:
Test
============
name              type                default val
id                   Autonumber     Increment
name            Text                   ""
submittedOn Date/Time           Now

Then if you execute the following query:
Insert INTO Test(name) Values('John')

Then the autonumber and the submittedOn fields will be filled automatically for you.
0
mstumpoAuthor Commented:
Thanks but I don't think that is going to work. New records are not going to be added. When a user edits his record to indicate he is out of the office, or in a meeting, I would like the edit.asp page to pull the date and time somehow so when the page is submitted for update, the date and time of the update is recorded.
0
hieloCommented:
OK. you don't have to perform an INSERT to use function Now. The db has a built in function named Now which gives you the current time. So in your case you would need and update statement:
UPDATE Test SET submittedOn=Now(), name='John' WHERE id=1
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

hieloCommented:
FYI: If you are using ASP with vbscript as your server-side technology, there's a built in function also named Now() which gives you the current date/time.
0
mstumpoAuthor Commented:
Here is the FP update query;
UPDATE SignInOut SET EmpName = '::EmpName::' , EmpTime = '::EmpTime::' , EmpComment = '::EmpComment::' , etc.

So you are indicating to change the EmpTime to
UPDATE SignInOut SET EmpName = '::EmpName::' , EmpTime = 'Now()' , EmpComment = '::EmpComment::' etc..

If so, that breaks the update.
0
hieloCommented:
No need for quotes.
UPDATE SignInOut SET EmpName = '::EmpName::' , EmpTime = Now() , EmpComment = '::EmpComment::' etc..

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mstumpoAuthor Commented:
Thanks! That was it. Tested and works. The existing manually entered time was replaced with today's date and current time. Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.