TABLE : tblSales +------------------------------------------- ---+ | ID | PRODUCT | DATE | TIME | +-------|--------------|-------------|----------+ | 1 | SAND | 11-Nov-2022 | 13:50:33 | | 2 | CEMENT | 11-Nov-2022 | 18:22:05 | | 3 | BRICKS | 12-Nov-2022 | 11:09:12 | | 4 | CEMENT | 13-Nov-2022 | 09:50:42 | | 5 | SAND | 13-Nov-2022 | 14:47:48 | | 6 | SAND | 13-Nov-2022 | 20:22:31 | | 7 | BRICKS | 15-Nov-2022 | 12:17:26 | | 8 | BRICKS | 16-Nov-2022 | 08:36:27 | | 9 | SAND | 16-Nov-2022 | 15:50:44 | | 10 | CEMENT | 20-Nov-2022 | 20:50:18 | +-------|--------------|-------------|----------+
Select * From tblSales Where [DATE] Between from_date And to_date And [TIME] Between from_time And to_time
... WHERE [DATE] + [TIME] BETWEEN ...
dd-MMM-yyyy
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)