Subject Filter for Date Range
From Patrick Healey <>
Date Tue, 20 Mar 2018 14:35:48 -0400
Newsgroups dbase.getting-started

Good afternoon!
Most of my tables have dates.  I would like to set a filter on a date range.  How is that done?  I have tried ctod(), dtoc(), dtos() and {}.  None worked - or at least not in the combination that I tried.
I want to supply a start and end date.  Then filter that on the date field in the table with an expression like:
form.xxxtable1.rowset.filter := "(Formdate > Start) AND (Formdate < End)"
I set Start = Date() - 365 and End = Date() + 1 in the On Open for the form.
Thank you in advance.

Pat Healey