Implementation of Date Range Prompt in Query Builder

[JDMTX]

Can someone adivse how to implement a date range prompt via a filter in the query builder interface in EG 4.3? I understand how to use prompts in open code but it is not clear how the date range prompt macro variables of _MIN and _MAX should be setup via the filter setup screen. Any help would be greatly appreciated.

jdm

[tomrvincent]

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.

[tomrvincent]

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