This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on QlikView Management.
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?
where Date>'17-01-2017 ' and Date<='30-04-2017';
View solution in original post
If you ommit the time part of the condition, does it work?
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'
I My self got it
great what you have tried ?
please close the thread.
sorry this doesn't seems to work