Hello,

I am having an issue creating a sales by hour calculation for my store employees. The issue is that when the sales are selected and sorted by date, the date is stored in datetime format, so when the time clock fields are added in, they do not select correctly because they are also in datetime, and do not exactly match the datetime of the sale. This typically causes the report to go haywire. Any thoughts are appreciated!

Thanks!
Anthony