AnsweredAssumed Answered

Attempting to set a date variable using ExecuteSQL

Question asked by Stu412 on Aug 15, 2015
Latest reply on Aug 15, 2015 by philmodjunk

Title

Attempting to set a date variable using ExecuteSQL

Post

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.

Thanks

 

Outcomes