Ho to make $X{[BETWEEN] with parameter of type date adding 1 day to end date

[mlopez_1]

Hi all, I like to do something like this in a query:

AND $X{[bETWEEN], ACTO_CLINICO_DATE, IC_GEN_DATE_START , IC_GEN_DATE_END + 1}

But raise an error.

This is why parameters are only DATE but the field ACTO_CLINICO_DATE is date with time.

If I use TRUNC(....) function invalidate predicate and deactivate the index, going very slow. If add 1 to end date I don't need to use TRUNC(...) and the query is very quick.

Regards,

 

Mariano