I am trying to write a query that will capture calls completed within 24 hours and calls completed > 24 hours, by call rep, based off of user selected from date and to date range in a web form. I have a column for completion_date
in the "yyyy-mm-dd 00:00:00" format, reps, type of call, call requested, and call assigned.
I really need some help!