Given two StartDate values (SDa, SDb) and two EndDate values (EDa, EDb) of a fully qualified date type:
No Overlap -- EDa < SDb OR EDb < SDa
Overlap -- SDb <= EDa AND SDa <= EDb
I have this written on a PostIt in my binder.
No Overlap -- EDa < SDb OR EDb < SDa
Overlap -- SDb <= EDa AND SDa <= EDb
I have this written on a PostIt in my binder.
No comments yet.