ODBC Query with current date

Was this issue really a hard one?

You need to generate the SQL string so that it contains the date - are you using MSQuery to run the extract?

Because you are using SQL Server by the looks of it and assuming you are currently using MSQuery, try this as the relevant element of the WHERE clause (you need to adapt the SQL string in the SQL window in MSQuery):

I tried replacing it and i get this error

SQL Query can't be represented graphically. Continue anyway? then it says Expected lexical element not found

OK! I figured it out!

WHERE ("BV:CallTracker"."Create-date">= {ts '2010-07-05 00:00:00'})

where the RED letters are you replace that with [Date] (the word Date can be changed to anything, like Date? or Date mm/dd/yyy, or any question/phrase you need it to be, the square brackets are the important part)

then when you go to return the data you can set the parameter to a specific cell. If you keep the squiggly brackets you aren't able to set a parameter for some odd reason. So, I will be testing it tomorrow to see if the data switches with the current date formula and if it does i'll post here.