Is it possible that EDATE IS NULL. If so I would add as the first criteria (EDATE IS NOT NULL AND (EDATE > 1/31/2017 AND EDATE <= 2/28/2017))
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Sunday, May 21, 2017 12:41 PM To: [email protected] Subject: [RBASE-L] - RE: Enhanced DBGrid Date Range Filtering Still learning about this form and trying to answer my own question… Changing it to OR doesn’t work either… From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, May 20, 2017 11:53 AM To: [email protected] <mailto:[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… 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] <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.
