Query = > today

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query = > today ? 3
Excel How to get the number of days an item was opened from the today's date. 14
Excel =SUM(A1=A1+B1) 0
Excel Excel Show Countdown Date 7
Date search query 0
calculating on dates 3
Daily Make Table Query 1
Convert 'Today' as double 1

Back
Top