Date Formula Help

[KGB]

Hello!

I have two fields that I want to meet certain criteria to return a value in another field.

Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date field is empty have this field stay empty

Thanks!

[TheTimeSavingCo · Accepted solution]

Does this look right? 

IF(
  {Date/Timestamp},
  IF(
    {Advanced Record} = "ADVANCED",
    IF(
      DATETIME_FORMAT(
        {Date/Timestamp},
        "HH"
      )>21,
      "Late",
      "On time"
    )
  )
)

[KGB]

Thank you!!