3 Replies Latest reply: May 17, 2013 11:12 AM by Stephen Jasionowski RSS

    load order for hour of day

      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?