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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

all previous days

Status
Not open for further replies.
phpatrick

phpatrick

Programmer
Jul 9, 2006
72
BE
what is shorthand to put in my query on a date field to say that he should show me all the records where the date is in the past. So every day of the past except today.

Is it possible to say NOT NOW() ?

 
Sort by date Sort by votes
As Eupher said but, since you chose Now() in your example,
maybe you do really want, everything prior to the current
time, not just the day?
So, everything before Feb 21/07 or, everything before
Feb 21/07 1:00pm?

small detail, maybe relevant?

< Now()?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
1K
Norman Sherlock
Norman Sherlock
Moss100
  • Locked
  • Question
Hiding or resizing Access Application so my pop up form is all that is seen by the user
Replies
2
Views
126
jedraw
jedraw
Moss100
  • Locked
  • Question
Function to strip all other than numbers from a field 1
Replies
5
Views
136
Moss100
Moss100
Cpreston
  • Locked
  • Question
What days is this looking at 2
Replies
5
Views
65
Andrzejek
Andrzejek
Ali Abbas
  • Locked
  • Question
Hi All, Firs I will be grateful
Replies
2
Views
59
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top