Using start/end-of-day functions to filter reported records for specified day

Requirement was for a report to accept a Date parameter and provide a list of records that have occurred on that date.

The attached document shows the configuration of 2 SQL functions, DateToStartOfDay and DateToEndOfDay, and their use to provide that functionality.

StartOfDayEndOfDayReportingFunctions.docx (228 KB)