XPath Date Comparison

What is the syntax to compare Dates from two entities with XPath? Here are two simple entities and attributes: Entity #1 – Order Name OrderDate Qty Price   Entity #2 – Report Name StartDate EndDate   Within a DataView of a Report, I want to create an XPath Data Source for a List View on the Order entity.  I want to filter the orders where the OrderDate falls between the StartDate and EndDate of the Report.  I will be using this to let the user select which orders they want to include in the report. How do I do this? Peace, Keith  
1 answers

Likely your Report entity has no association to the Order entity, because logically there is not any relation between the two.

Rather then creating a XPath datasource, create a microflow datasource and in that microflow retrieve Order using $Report's dates like this: