I have two date fields. I have to determine if the date
in one of the fields falls either before or on the same
day as the other field. I was using the following logic:
If MySet![Exp Arrival] <> 0 And MySet![DueDate] > MySet!
[Exp Arrival] Then
MySet![OnTime] = 1
ElseIf MySet![Exp Arrival] = MySet![DueDate] Then MySet!
[OnTime] = 1
MySet![OnTime] = 0
This worked fine before, however, the format of the data
that is being input into my database now has time stamped
information on it. If my duedate is 7/6/03 11:50 AM, and
my Exp Arrival is 7/6/03 12:01 PM, the above logic will
show that OnTime would be 0, when it should be 1. Is
there a way to work around this so I don't have to change