If both are date time attributes (so a seperate one for the start date and a seperate one for the enddate) you can use the functions < or > or <= and >= to check if one date is greater or smaller as another date. This way you could check if one date time is between two other date time attributes.
Regards,
Ronald