Using Today's date as MSQuery filter criterion

Posted on 2012-08-29
Last Modified: 2012-08-29
With Excel 2010, I am querying a SQL database using msquery.
 I am trying to use today's date as a criterion.
The criterion being 'select to_date if to_date is greater than or equal to today's date'

I have tried:
All to no avail.

The error message for each of these is:
'today' is not a recognized built-in function name. Statement(s) could not be prepared, etc....

Please see attached sample screenshot.
Can anyone clarify please?
Question by:David Phelops
    LVL 12

    Accepted Solution

    Try getdate()

    Author Closing Comment

    by:David Phelops
    Thank you very much indeed.
    That worked a treat!

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now