Joined: 27 Jun 2012
Location: United States
Online Status: Offline
Posts: 2
Topic: Report data by time range Posted: 27 Jun 2012 at 6:16am
I am attempting to alter an existing report to include ONLY law enforcement calls within a time range (midnight to 7am) for calls in a date period; i.e., 2010, 2011, etc. Unfortunately, as far as I can find, all the database fields relating to time are date AND time, none with time only. How can I include only these time periods, but still have the report show for multiple dates? Below is my current formula:
{CallUnits.CallUnitNumber} in ["D6", "D1", "D2", "D3", "D4", "D5", "DCSO"] and {Call.ReceivedTime}= datetime({?Begin Date}) to datetime({?End Date},time(23,59,59)) and {CallUnits.CallUnitDispatchedFrom} in ["1DCSO", "2 DCSO", "4DCSO"]
Thank you in advance for taking time to help..... John
Joined: 27 Jun 2012
Location: United States
Online Status: Offline
Posts: 2
Posted: 27 Jun 2012 at 8:42am
Thank you! I has tried that, but it kept reverting back to the original after I exited the "Select Expert". But now I know what was happening.... I was just exiting out of the window with the "X"... I needed to "Hide Formula", then click "OK" to exit. Thank you for your help!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum