Date query in excel as database

Question

Hi,

I am using excel as database & pass date of birth (picked from excel) in an update query as below :

Update eSheet1$$] set Status ="Matched" where DOB ='11/10/2022' but I am getting a syntactical error pop up.

Can anyone please help me with conversion or casting or is there anything else that I am missing

Page 1 / 1

@Abhishek Mishra Switch the double quotes for single ones around 'Matched'

Failing that - what is the message you are seeing? Will help diagnose.

Paul Hawkins · Answer

@Abhishek Mishra​Switch the double quotes for single ones around 'Matched'Failing that - what is the message you are seeing? Will help diagnose.

Sign up