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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Querying date/time access

I have a field in an access database that looks like this "05/08/1986 11:30:00 AM" and I want to query it to just get this, "05/08/1986".

How do I do that?
0
Coaster_brook_trout
Asked:
Coaster_brook_trout
  • 3
2 Solutions
 
mbizupCommented:
On your form, set the format property of that textbox to "Short Date"


You can also set the format property of the field in the underlying table or in the query itself to Short Date
0
 
pcelbaCommented:
You may use FORMAT function:

FORMAT(YourDateTime, "mm/dd/yyyy")

More info: http://www.techonthenet.com/access/functions/date/format.php
0
 
mbizupCommented:
To do this right in the query...Short Date
0
 
mbizupCommented:
Coaster_brook_trout,

Was there something we should have done to make the responses more clear?

Take a look at EE's grading guidelines here:
http://support.experts-exchange.com/customer/portal/articles/481419-what-grade-should-i-award-?b_id=44

A B grade means the solution given lacked some information or required you to do a good amount of extra work to resolve the problem. When closing the question, the asker should explain why a B grade was awarded.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now