Between Times (1 Viewer)

[RandyC]

I have a start time and an end time for several records on a given day. I am allowing the user to enter a new start and end time for a new record. I am trying to check the new start time to see if it between any of the preious times that have been entered. I thought the between function could possably work but have had no luck.

 

[Wicklund]

I may be over simplifying, but you could try:

If [Start Time (New)] >= [Start Time (Old)] then
If [Start Time (New)] <= [End Time (Old)] then
'Your error message here"
End If
End If