AnsweredAssumed Answered

ExecuteSQL Date fields

Question asked by on May 14, 2018
Latest reply on May 14, 2018 by

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?