03-22-2011 04:20 PM
08-31-2017 09:27 AM
I'm trying to do this as well. QB adds a where clause like this:
WHERE %_eg_WhereParam( t1.CLCL_PAID_DT, Paid_Dates, EQ, TYPE=D, IS_EXPLICIT=0 );
but I haven't gotten it to work and it doesn't show Paid_Date_Min or _Max as available prompts.
I might have to get rid of the date range macro variable or add a redundant begin_paid_dt and end_paid_dt.
08-31-2017 09:38 AM
I solved it!
use a 'between range' and you can use a date range macro variable.
it'll generate this filter: WHERE %_eg_WhereParam( t1.CLCL_PAID_DT, Paid_Dates, BETWEEN, TYPE=D, IS_EXPLICIT=0 );
here's a video to explain it. https://www.youtube.com/watch?v=zgk3lJzcIPo