MSSQL Syntax Issue Querying Date Field

[rwhirn]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): Microsoft SQL 2014

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Build 279

3. The steps to reproduce this issue: The top query does not work. The bottom one does. The top query gives an error This is the query as shown in the log pane:

-- 2024-09-09 18:02:17.6988
SELECT  * FROM [dbo].[ictrsnh] WHERE [dtrs] BETWEEN ''2022-11-01'' AND ''2022-11-30'' ORDER BY [cuid] OFFSET 0 ROWS FETCH NEXT 1800 ROWS ONLY;