Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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'
try this
Where
where Date>'17-01-2017 ' and Date<='30-04-2017';
I My self got it
great what you have tried ?
please close the thread.
sorry this doesn't seems to work