Discussion board where members can get started with QlikView.
I'm putting this into my script but its not returning the data I expect, what am I doing wrong?
DateRaised>='01/06/2010' and DateRaised<'31/05/2011';
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.
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:
DayStart(DateRaised) >= DATE('01/06/2010', 'DD/MM/YYYY') and DayStart(DateRaised) < DATE('31/05/2011', 'DD/MM/YYYY');
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?