Assuming that you have the date in a variable. You could use something like
$MyDateVar >= $Table/StartDate and $MyDateVar <= $Table/EndDate
If you’ve already tried something of this sort elaborating your question would help.
EDIT – Andreas you beat me to it :)
You could already do that in the retrieve by adding an xpath constraint. Something like:
[StartDate >= $StartOfDateRange and EndDate < $EndOfDateRange]
This example assumes that the variables $StartOfDateRange and $EndOfDateRange are initialized with start and end.