This content has been marked as final. Show 3 replies
I'm having trouble getting an hour of day order set up to count calls made during certain hours. the format i have is h TT - h+1 TT (e.g. 2 PM - 3 PM). This is the line of code i'm using in the script to define that:
time(maketime(Hour([calltime])), 'hh TT') & ' - ' & time(MakeTime(Hour([calltime])+1), 'hh TT') as [Call Hour]
I tried using a mapping load for call hour order starting with 12 AM - 1 AM as 1, 1 AM - 2 AM as 2, etc. and then sorting by call hour order as an expression but that didn't work. any thoughts?