Hello, I have a table that has three fields. ActualNext(DateTime), CompletedDate(DateTime), OnTime(Calculated : either 1 for being on time or 0 for being late)
The expression that I am using in the OnTime field is :
IIF([CompletedDate]<=[ActualNext],"1","0")
This is working for some of the...