AnsweredAssumed Answered

BOXI Report Assistence

Question asked by lilmoss on Oct 18, 2016
Latest reply on Oct 26, 2016 by lilmoss

Hi Everyone,

 

I need to create a BOXI report for CA SDM tickets that were touched by an analyst between the hours of 2:00 am and 12:00 noon on a monthly basis.  My thought would be to create a variable something like this: =If [Format Date] Between("09-01-2016"; "09-30-2016") And [Format Time] Between("02:00:00 a"; "12:00:00 p") Then [Open Date]

The variable Format Date is =FormatDate([Open Date]; "mm,dd,yyyy") and Format Time is =FormatDate([Open Date]; "hh:mm:ss a"), but this isn't giving me any results on the report.  What am I missing?

 

Thanks,

 

Joyce Lilie

Outcomes