Not able to use "Is Between" default operator for date filter in query.

[Former Member]

Hi Experts,

We have developed one custom query and in that we have Expiration date filter for this filter we have selected default operator is "Is Between".

But when we run the query it is not providing second date filter against expiration filter.

Example: In list channel when we run Search Master Agreements query if we select "Is Between" operator for Expiration Date filter it is providing second date filter against this. Please see below screen shot.

But when we select "Is Between" in query filter it is not providing second date filter. Please see below screen shots.

 

We have added this query in report and tried but no luck.

Can anyone help us on this, how to achieve this in query definitions?

Thanks in advance!!

Regards,

Lava.

[Former Member · Accepted solution]

Hi Lava,

Append T1.EXPIRATION_DATE_DATE BETWEEN ? AND ? in WHERE clause of your query. Under Filter parameters, you need to create 2 filters with Date data type and Default Parameter as In Between. Find the attachment below.

This will work!!!

Regards,

Vignesh

[Former Member · Accepted solution]

Hi Vignesh,

Thanks for your helpful information.

Regards,

Lava.