topic Re: SQL Date in QlikView

SQL Date

Smeenakshi23 — Mon, 26 Jan 2026 18:19:17 GMT

Hello

I have a SQL date condition like

Where DATE BETWEEN '17-01-2017 00:00:00' AND '30-04-2017 23:59:59' , When I ran this script in Qlikview it throws "Invalid month error"

How to change or hardcore the date condition?

dapostolopoylos — Mon, 30 Jul 2018 10:31:12 GMT

If you ommit the time part of the condition, does it work?

tresB — Mon, 30 Jul 2018 10:32:27 GMT

Perhaps, this is a format issue. Try interchanging DD with MM, like:

Where DATE BETWEEN '01-17-2017 00:00:00' AND '04-30-2017 23:59:59'

Chanty4u — Mon, 30 Jul 2018 10:34:58 GMT

try this

Where

where Date>'17-01-2017 ' and Date<='30-04-2017';

Smeenakshi23 — Mon, 30 Jul 2018 10:38:00 GMT

I My self got it

Chanty4u — Mon, 30 Jul 2018 10:39:21 GMT

great what you have tried ?

please close the thread.

Smeenakshi23 — Mon, 30 Jul 2018 10:43:50 GMT

sorry this doesn't seems to work