G
Guest
I wasn't sure if this is the best place to post this question...
I am trying to check a date range in a table (fields are BeginningDate and EndingDate) whenever a new record is added. The new record will also have a date range associate with it (fields are the same - BeginningDate and EndingDate). New date ranges cannot overlap existing date ranges at all. I pretty much have everything in line except for the actual comparison of the dates.
Can someone offer a solution to check one date range against another?
Thanks,
Clint
I am trying to check a date range in a table (fields are BeginningDate and EndingDate) whenever a new record is added. The new record will also have a date range associate with it (fields are the same - BeginningDate and EndingDate). New date ranges cannot overlap existing date ranges at all. I pretty much have everything in line except for the actual comparison of the dates.
Can someone offer a solution to check one date range against another?
Thanks,
Clint