Attempting to set a date variable using ExecuteSQL
I'm looking to use a ExecuteSQL statement to select a date from a date field, place it in a variable and use it elsewhere.
The 'where' criteria are quite complex, hence the use of SQL. Basically, I've got:
Set Variable [ExecuteSQL "Select Date from DataTable where...criteria1....criteria2 etc."]
I think the problem is with the use of SQL and date formats, but I'm not sure how to simply get 31/01/2015 from table A to table B, so to speak.