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 fields, like entering CompletedDate (1/1/2018) and ActualNext (1/15/2018) results in OnTime being 1.
However, when I have a CompletedDate (1/1/2019) and ActualNext (1/15/2019) it results as a 0.
I am trying to figure out why this is happening. It does not make sense that it would work correctly for one field but not another field. I would appreciate anyone's thoughts/feedback on what I might be doing wrong.
Thanks!
The expression that I am using in the OnTime field is :
IIF([CompletedDate]<=[ActualNext],"1","0")
This is working for some of the fields, like entering CompletedDate (1/1/2018) and ActualNext (1/15/2018) results in OnTime being 1.
However, when I have a CompletedDate (1/1/2019) and ActualNext (1/15/2019) it results as a 0.
I am trying to figure out why this is happening. It does not make sense that it would work correctly for one field but not another field. I would appreciate anyone's thoughts/feedback on what I might be doing wrong.
Thanks!