AnsweredAssumed Answered

ExecuteSQL Date fields

Question asked by dlewis@taylor.n-lanark.sch.uk on May 14, 2018
Latest reply on May 14, 2018 by dlewis@taylor.n-lanark.sch.uk

I'm trying to run a script which will find records which have 10 as the month using wildcards.

 

Contrived I know, but its for a solution to an exercise written for Access, I'm adapting the questions/answer for my pupils.

 

Script I have written is as follows:-

 

ExecuteSQL ( "

 

 

SELECT MembershipNumber, DateOfBirth, TypeOfMember FROM Member

WHERE TypeOfMember = 'Adult' AND DateOfBirth LIKE %10%

 

 

 

 

";"";"" )

Any ideas how to get this working?

 

What is the correct syntax for the use of dates in ExecuteSQL?

Outcomes