Skip to Content
Former Member
Jun 06, 2010 at 06:59 AM

Date Restriction by other date in Query Designer


Hi Guys,

I need help to sort out the below.

I have in my Query DATE_1 to restrict the query as Interval Variable, then in the query results I have DATE_2 as result char.

I have DATE_3 and I need to display the query based on DATE_3.

and the logic for DATE_3 is for each Customer DATE_2 has multiple records of DATE_3 and I want to display the records where DATE_3 in range between DATE_2 <= DATE_3 >= DATE_2+30.

how can I do this in Query designer.