Home > IT Answers > Microsoft Windows > Current Date in Excel Query
Jameb12
20 pts.
 Current Date in Excel Query
Excel 2003, Excel formulas, Excel queries, Microsoft Excel, Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!

Software/Hardware used:
ASKED: July 17, 2008  6:32 PM
UPDATED: July 17, 2008  7:45 PM
RELATED QUESTIONS
Answer Wiki:
Have you tried the @TODAY() function? I've always had success with this in the past.
Last Wiki Answer Submitted:  July 17, 2008  7:35 pm  by  Awestb   15 pts.
All Answer Wiki Contributors:  Awestb   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I tried the @TODAY() function but it didn’t work. I need the dates to show all that are greater than or equal to the current date.

Jameb12
 20 pts.