This is a canvas app connecting to an Azure MS SQL database. The data field contains date/time. The filter is to get all records matching a specific date from DatePicker (even if I hard code a specific date in the Filter, still wrong result). Records contains date/time starting at 12:xx am of the filter date are omitted. Records starting at 12:xx am of the next date are included in the result.
For example, the search date is 5/21/2022. Records with date 5/22/2022 12: 05 am is returned, but record with date 5/21/2022 12:05 am is not. I suspect this has something to do with time zone.
Code:
Filter(Attendance,
checkIn >= DatePicker1.SelectedDate,
checkIn < DateAdd(DatePicker1.SelectedDate, 1, Days))