Using Query to filter a form for BETWEEN two date ranges

[cwjonss]

I’m simply trying to filter a form for a date range between two dates, which are determined by two controls on a separate form.

As I can seem to filter the form for dates after a date specified in a control:

>[forms].[front.form].[after_date]



I would have thought I could simply use:
Between >[forms].[front_form].[after_date] and <[forms].[front_form].[before_date]

But that tells me the date value is invalid in the query.

I’ve tried:
>[forms].[front_form].[after_date] and <[forms].[front_form].[before_date]

which works but seems to only filter for the [before.date] range.

Any help would be greatly appreciated!

[Minty]

You were close - with the Between construct you lose the < > operators as they are implied. Try

Between [forms].[front_form].[after_date] And [forms].[front_form].[before_date]

[cwjonss]

wow, cannot believe I didn't try that. Must have spent 2 hours trying to figure this out!

Absolute lifesaver, thanks for the help!