Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

=date() not able to display time in query

Posted on 2014-02-24
2
Medium Priority
?
272 Views
Last Modified: 2014-02-24
hello,
am using the = date() in a invisible textbox on a form- users enter data in-
now admin wants to be able to see the date and time
cannot seem to have it display in a date time ( general) format- tried changing it in query and also in properties of table-
any ideas what I can do to have it display date and time?
thank you
0
Comment
Question by:davetough
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1600 total points
ID: 39884005
use  =Now()  instead of Date()
0
 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 400 total points
ID: 39884179
You may also need to select the correct format for the textbox, probably General Date
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question