Hi there I am trying to write a reusable SQL statement that I can run daily where I can select all the records in my table before 13:00:00 each day.
My date format is stored as a date time stamp I have looked at using the date part function but I can't get it working.
SELECT datePart("hh",CustTable.[Log Time]) AS Hour
WHERE ((CustTable.[Booklet Received])=1 and hour <= '13:00:00');