2 Replies Latest reply on Apr 26, 2016 11:06 AM by barraa007

    Finding a time between two times

    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!