Month Problem in Load Script

Sat, 12 Mar 2011 17:30:18 GMT

Hi guys,

I have an application where I have a date field and it has been reformatted to be of the form 'MMM-YYYY'.

The problem I now have is that in my load script when I try to specify a WHERE condition to show dates where date >= 'Jan-2010' and <='Feb-2011', it does not work as expected and ends up pulling the wrong date months and not the dates I expect to see.

Can anyone give me pointers on how to fix this so I can actually see months between Jan2010 and Feb2011?

Thank you

Month Problem in Load Script

tresB — Sat, 12 Mar 2011 19:27:06 GMT

Hi,

try this:

Where Date >=Date#('Jan-2010','MMM-YYYY') And Date <=Date#('Feb-2011','MMM-YYYY')

Regards, tresesco

topic Month Problem in Load Script in QlikView

Month Problem in Load Script

Month Problem in Load Script