Hi all, I have two date columns named as 'beg...

[Alper]

Hi all, I have two date columns named as ‘begin’ and ‘end’, formatted mm/dd/yyyy. When user wants to enter these dates for a new record, I want to prevent entry;

if either of start or end date falls ON or WITHIN any of the start-end date ranges in any existing rows, or; entered same dates (‘end’ must be a day later, at least).

In other words, I want new start-end days range entered into a completely unallocated space, in a monthly calendar. Of course, a gannt chart, or at least a calendar view with occupied days marked, would be very helpful here for user

(I voted for gannt chart, btw ). The solutions i can think of, involve calculations on several extra columns, but feeling this can be done in lesser steps. How this can be accomplished, any ideas? ie, converting all ranges to a large list and check against this list, if such a way possible…