Month Problem in Load Script

[#1]

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

[tresesco · Accepted solution]

Hi,

try this:

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

Regards, tresesco