Still learning about this form and trying to answer my own question… Changing it to OR doesn’t work either…
[cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, May 20, 2017 11:53 AM To: [email protected] Subject: [RBASE-L] - RE: Enhanced DBGrid Date Range Filtering I’m trying to answer my own question and have found CTRL-L hotkey to bring up DIALOG SEARCH. I have tried Condition: BETWEEN and Value: date1 and date2 and (date1 and date2) and even ((CTXT(DATE1)) AND (CTXT(DATE2)))… Using Greater than a single date works fine. Conclusion: I’m entering my criteria wrong… [cid:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, May 20, 2017 11:18 AM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - Enhanced DBGrid Date Range Filtering Last January (1/25/17), Razzak suggested these methods to pick a single date (today’s date). Short of filtering the table before opening the dbgrid, is it possible to FILTER or SEARCH a range of dates? TIA, Claudine Part 1: -- A very simple technique ... Button Caption: [Show Today's] On Click EEP: -- Show Today's PROPERTY DBGrid_Invoices FILTERS->COLUMN_NAME->TransDate .#DATE RETURN Or Part 2 ... If you would like the SEARCH option of the Enhanced DB Grid, use the following technique to accomplish your goal. Here's how: -- A very simple technique ... Button Caption: [Show Today's] On Click EEP: -- Show Today's SET VAR vSearch TEXT = + ('PROPERTY TABLE InvoiceHeader SEARCH->TransDate->'+(CTXT(.#DATE))) &vSearch RETURN -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
