Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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