I have a query that is supposed to show records from 2022-12-01 to 2022-12-30 but it shows no data. Here’s my SQL string
Select SUM([Quantity]) as "All Quantity" from [InventoryLog] where [Date] BETWEEN '2022-12-01' AND '2022-12-30'
but when I set the years in the date parameters to 1922, there shows data when I execute the query.
Select SUM([Quantity]) as "All Quantity" from [InventoryLog] where [Date] BETWEEN '1922-12-01' AND '1922-12-30'
Am I missing something?
Version: 188.8.131.52 (x86) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_PH); UI: en-US