In a table called GROUP_VISIT_T, I have two times stored as Date/Time (ShortTime) datatypes.
Their respective fields are "Visit_Start_Time" and "Visit_Finish_Time".
I want to add a validation rule so that a user cannot enter times that have a difference of more than 8 hours.
How do I do this?
I have tried entering Validation Rules like:
DateDiff ("n", [Visit_Start_Time], [Visit_Start_Time])/60 < 8
....but without any luck so far!
Cheers,
Stanbridge