DateDiff Validation in Table

[stanbridge]

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

[orange]

Do it on a Form. You could use Control's After Update event. You shouldn't let user deal directly with a Table.

[ssanfu]

<snip>

I have tried entering Validation Rules like:
DateDiff ("n", [Visit_Start_Time], [Visit_Start_Time])/60 < 8
....but without any luck so far!

<snip>

Well, I would have used "[Visit_Finish_Time]" somewhere in the DateDiff() function.

Also, I would use the Before Update event in a form rather than validation in a table.... you have more control over validation. You can change color of the control, default the value to a desired number, set the focus to the control. Can't do that doing validation at the table level.

[stanbridge]

Thanks Orange and Steve!

Point taken, I will do it at the form level. I think I was getting ahead of myself!

And yes Steve, I was getting lazy with my copy and paste and forgot to change the second "Visit_Start_Time" to "Visit_Finish_Time"!


Cheers,
Stanbridge