Subject Filter for Date Range From Patrick Healey <healeyp1947@gmail.com> 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