Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Smeenakshi23
Creator II
Creator II

SQL Date

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?

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try this

Where

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

View solution in original post

6 Replies
dapostolopoylos
Creator III
Creator III

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

Father/Husband/BI Developer
tresesco
MVP
MVP

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
MVP
MVP

try this

Where

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

Smeenakshi23
Creator II
Creator II
Author

I My self got it

Chanty4u
MVP
MVP

great what you have tried  ?

please close the thread.

Smeenakshi23
Creator II
Creator II
Author

sorry this doesn't seems to work