Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Dates where clause not working

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
Labels (1)
3 Replies
Or
MVP
MVP

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
Creator II
Creator II
Author

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

sidhiq91
Specialist II
Specialist II

@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.