468,301 Members | 1,459 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

Query = > today

I'm trying to create a query that will show only the records that has a date
of today or after in the date field (consequently my results would change
everyday).

I tried >=#today# but that didn't work.

Is there a way to do this? If so how?

Thanmks.
Nov 19 '05 #1
2 1538
Sorry, I posted this to the wrong group!

"Glenn" <no****@yahoo.com> wrote in message
news:Oe**************@TK2MSFTNGP12.phx.gbl...
I'm trying to create a query that will show only the records that has a
date of today or after in the date field (consequently my results would
change everyday).

I tried >=#today# but that didn't work.

Is there a way to do this? If so how?

Thanmks.

Nov 19 '05 #2
Even though its a wrong group, I'd like to put in ur answer here so that
others who might stumble across this discussion thru google can benefit.
You can use the function GetDate() is T-SQL, or if you are passing the data
from the UI, you can get the data usig the functions Date.Today()
Hth...
R. Thomas

"Glenn" wrote:
Sorry, I posted this to the wrong group!

"Glenn" <no****@yahoo.com> wrote in message
news:Oe**************@TK2MSFTNGP12.phx.gbl...
I'm trying to create a query that will show only the records that has a
date of today or after in the date field (consequently my results would
change everyday).

I tried >=#today# but that didn't work.

Is there a way to do this? If so how?

Thanmks.


Nov 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Fred Thompson | last post: by
2 posts views Thread by Mike B | last post: by
2 posts views Thread by John | last post: by
6 posts views Thread by davegb | last post: by
10 posts views Thread by Brian W | last post: by
2 posts views Thread by tshad | last post: by
10 posts views Thread by recordlovelife | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.