FIND with BETWEEN

robleer

Hi,

I have a simple problem which I cannot solve (maybe I'm staring to long at a simple thing 🙂 )

This works:
FIND OpslagContractDatum WHERE OpslagContractDatum.Datum>=CURRENT_DATE-3

This works:
FIND OpslagContractDatum WHERE OpslagContractDatum.Datum<=CURRENT_DATE+3

This does not work (no rows returned):
FIND OpslagContractDatum WHERE OpslagContractDatum.Datum>=CURRENT_DATE-3 AND OpslagContractDatum.Datum<=CURRENT_DATE+3

This does NOT work
FIND OpslagContractDatum WHERE OpslagContractDatum.Datum BETWEEN (CURRENT_DATE-3) AND (CURRENT_DATE+3)

This works (but is useless of course:
FIND OpslagContractDatum WHERE OpslagContractDatum.Datum BETWEEN (CURRENT_DATE) AND (CURRENT_DATE)

TIA,

Rob

robleer

I found a solution myself

This works:

FIND OpslagContractDatum WHERE
OpslagContractDatum.Datum BETWEEN DATE_ADD (CURRENT_DATE, -3) AND DATE_ADD (CURRENT_DATE, 3)

joben

robleer wrote
I found a solution myself

This works:

FIND OpslagContractDatum WHERE
OpslagContractDatum.Datum BETWEEN DATE_ADD (CURRENT_DATE, -3) AND DATE_ADD (CURRENT_DATE, 3)

I was just about to post this suggestion 😃

My experience is that this way of writing the query tends to work better.