Expression for finding all matching rows between 2 dates

[Austin_Nunns]

Hey Everyone,

I’m trying to write an expression for finding all matching rows that fit between 2 selected dates. Here is the structure:

I have a table that asks for the date.
I have a seperate table that is for exporting. So it asks for a begin date and an end date.

What I would like to do is to have the data show only what is between the begining and end date. I tried using the < and > it gave me an error saying that it cannot compare a list to a date.

[Jonathon]

SELECT(table[id],AND(
   [date]<=[_THISROW].[high_date],
   [date]>=[_THISROW].[low_date]
))