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 Chriss Miller 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
Joined
Jul 9, 2006
Messages
72
Location
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
phpatrick,

How about [blue]< Date()[/blue]?

Ken S.
 
Upvote 0 Downvote
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 Question
Message Box Popup on certain days help !
2
Replies
23
Views
7K
Norman Sherlock
Norman Sherlock
Moss100
  • Locked
  • Question Question
Hiding or resizing Access Application so my pop up form is all that is seen by the user
Replies
2
Views
460
jedraw
jedraw
Moss100
  • Locked
  • Question Question
Function to strip all other than numbers from a field
Replies
5
Views
484
Moss100
Moss100
Cpreston
  • Locked
  • Question Question
What days is this looking at
Replies
5
Views
303
Andrzejek
Andrzejek
Ali Abbas
  • Locked
  • Question Question
Hi All, Firs I will be grateful
Replies
2
Views
259
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top