Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
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
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');
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?