SQL Date

[Smeenakshi23]

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?

[dapostolopoylos]

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

[tresesco]

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 · Accepted solution]

try this

Where

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

[Smeenakshi23]

I My self got it

[Chanty4u]

great what you have tried  ?

please close the thread.

[Smeenakshi23]

sorry this doesn't seems to work