Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date question - easy

Status
Not open for further replies.
lcan

lcan

Technical User
Joined
Mar 1, 2003
Messages
5
Location
US
How do I format a date and time field in a query to pull data for items >1/1/2002 and < date()-1???
 
Sort by date Sort by votes
use the format command on the data you want to convert
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question Question
Max Date Qry
Replies
3
Views
1K
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
872
mikrom
mikrom
datajockey123
  • Locked
  • Question Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
999
dhookom
dhookom
caykamanj1966
  • Locked
  • Question Question
Get Yesterday's Date
Replies
1
Views
644
caykamanj1966
caykamanj1966
JayRo71
  • Locked
  • Question Question
Unable to sort date field
Replies
4
Views
593
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top