Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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';

View solution in original post

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