AnsweredAssumed Answered

Finding a time between two times

Question asked by barraa007 on Apr 26, 2016
Latest reply on Apr 26, 2016 by barraa007

I have a time field that shows the time of day, no date, that a referral was taken. I want to have a calc field show if the referral was taken between 7am and 7pm ("Day") or 7pm and 7am ("Night"). I can't seem to make this work using an If statement. It doesn't like my time format in the calc (00:00:00) for some reason. I tried:

If (Timefield > 07:00:00 and Timefield < 19:00:00 ; "Day" ; "Night" )

 

And several other variations. I would be grateful if someone could get my befuddled brain pointed in the right direction... Thnx!

Outcomes