Solved: MS Access Date Manipulation

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

draceplace

Thread Starter
Joined
Jun 8, 2001
Messages
2,583
I have a date stamp in a table that looks like:
09/16/2008 4:03:27 PM
If I run the Query = 09/16/2008 I get no answers because the time portion?
It seems the DatePart function works in reports and forms but not in queries?
Seems there should be a simple way to query this with out reprocessing the date field?

Thanks for looking!!
 
Joined
Oct 20, 2004
Messages
7,837
Like "*09/16/2008*" in your query will work, but that will be tedious if you have to do a lot of it.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Use Format([name of Date field], "mm/dd/yyyy") as seperate Column heading and then test that column instaed of the real date column.
[name of Date field] is the actual name of your Date Field in square brackets.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top