Create a computed item with this:
ToChar ( Start_Dt_Tm, ‘hh:mm:ss’)
This will put the time in a separate column that you can then limit on (time will be in 24-hour format). Replace the Start_Dt_Tm field with the relevant field you are working with.
Why would you want to do this?
You are looking at two weeks of data results from the Start_Dt_Tm field which were pulled from the Phr_Te_Time_Slice_Fm_T table. You need to limit the information to those entries where the Start_Dt_Tm is greater than or equal to 1:00AM and less than or equal to 5:00AM on any given day.
The dates and times are combined in the same field which makes it difficult to create a limit just based on the time parameters.
Last updated: August 7, 2014