topic Date range not working in QlikView

Date range not working

Thu, 21 Jul 2011 14:31:44 GMT

I'm putting this into my script but its not returning the data I expect, what am I doing wrong?

WHERE

DateRaised>='01/06/2010' and DateRaised<'31/05/2011';

Thanks

Date range not working

swuehl — Thu, 21 Jul 2011 14:59:08 GMT

Hi,

I think you have to take care that your literal date format (i.e. '01/06/2010') matches exactly the format which is expected by your SQL Select or LOAD statement.

Regards,

Stefan

Date range not working

Thu, 21 Jul 2011 15:07:59 GMT

Hi,

Try this

WHERE

DateRaised>=DATE('01/06/2010', 'DD/MM/YYYY') and DateRaised<DATE('31/05/2011', 'DD/MM/YYYY');

Verify if your field "DateRaised" are just DATE or DATETIME.

If DATETIME you can do this:

WHERE

DayStart(DateRaised) >= DATE('01/06/2010', 'DD/MM/YYYY') and DayStart(DateRaised) < DATE('31/05/2011', 'DD/MM/YYYY');

Date range not working

danielrozental — Thu, 21 Jul 2011 15:16:55 GMT

function Date doesn't create a Date field, it only formats one.

Are you sure field DateRaised is being recognized as a date field? are values aligned to the right when you select that field in qlikview?