Dates where clause not working

[D19PAL]

Hi, 

Quick easy one for you,

Don't know why this Sales date where clause ain't working.

When I do Sales Date = 01/03/2023 ----------- that works

When I do Sales Date >= 01/03/2023 ---------- doesn't work gives everything over 01, ignores the month and year

FROM [lib://Data.QVD]

(qvd)

where

"Sales Date" >= '01/03/2023' and "Sales Date" <= '31/03/2023'

;

Cheers

[Or]

Sounds like you're filtering on a text field, not a date. You'll need to convert it to a date before storing to QVD, or explicitly convert it in the WHERE condition.

[D19PAL]

It's definitely a date, in the date picker extension it picks it up as a date.

[sidhiq91]

@D19PAL  as @Or mentioned you may have to convert something like below in the where condition

where date#([Sales date],'DD/MM/YYYY') >='01/03/2023'

or may be try

where trim([Sales date])>='01/03/2023'

If this resolves your issue, please like and accept it as a solution.