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?