How to check the date range not repeate on the exist record?
Posted on 2001-07-10
I have a employee holiday database, its structure is:
EmpNo StartDay EndDay Part
(Part field option: Morning, Afternoon, AllTheDay)
before post a new record, I need to check its range not repeate on the exist record.
already have this record:
1 2001-4-16 2001-4-20 AllTheDay
the user can't add the following records.
1 2001-4-18 2001-4-22 AllTheDay
1 2001-4-20 2001-4-20 AllTheDay
1 2001-4-20 2001-4-20 Afternoon
How to do it? Thanks.