Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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.