It is very simple, but my calc is not giving me any result at all:
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)
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