Simple Calculation withTime Field

Discussion created by jayankurian on Sep 25, 2017
Latest reply on Sep 25, 2017 by Jason Wood

It is very simple, but my calc is not giving me any result at all:

Three fields

Name       - Text Field

ID Number - Text Field

Arrival Time - Time (arrival time is always blank when you enter the record but later we populate the field)


What I am asking is:

If Name > "a" and ID Number >"a" and Arrival Time <"00:00:00"; 1)


I tried

Arrival Time = " " (blank)

Arrival Time <"0"

Arrival Time <"00:00"


None of those option give me any output.


What is wrong with this simple calc?  I am using FMA16


Thank you