Can you get the result of the Accession Time as a number or time instead of text?
Accession Time result was in Time.
Accession Time: 1:50 AM (which is the calculation result – Right ( Accession Timestamp ; 8 ) Result is in Text
First thing: change the calculation formula to =
GetAsTime ( Accession TimeStamp )
and the result type to Time. Then make the second calculation =
Case ( Accession Time ≤ Time ( 8 ; 0 ; 0 ) ; “Tour I” )
I made the change as you suggested, not seen any result.
Also, I need to extract Tour II (criteria: > 08:00 AM and <=04:00 PM) Tour III (criteria >04:00 PM and <= 11:59 PM) from the Accession Time.
As you suggested, case statement is the best choice for the calc.
Michael Horak wrote:
Does the attached work for you?
YES it did.......
Thank you very much for your help.
Have a nice weekend.