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
FIND with BETWEEN
FIND with BETWEEN
Using 8.7 Professional 3025 on MySQL/Windows
Re: FIND with BETWEEN
I found a solution myself
This works:
FIND OpslagContractDatum WHERE
OpslagContractDatum.Datum BETWEEN DATE_ADD (CURRENT_DATE, -3) AND DATE_ADD (CURRENT_DATE, 3)
This works:
FIND OpslagContractDatum WHERE
OpslagContractDatum.Datum BETWEEN DATE_ADD (CURRENT_DATE, -3) AND DATE_ADD (CURRENT_DATE, 3)
Using 8.7 Professional 3025 on MySQL/Windows
Re: FIND with BETWEEN
I was just about to post this suggestion
My experience is that this way of writing the query tends to work better.