if you say date(week_planinng) you will only get a date eg. 22 and you cannot filter on 22
so where week_planning >= '2011-01-01'
for instance if you want a hardcoded day.
Do you want the todays date
week_planning >= Today()
HOWEVER - make sure the date Today is givning you is the same format as in Week_planning
Normally its SET DateFormat='DD-MM-YYYY'; for my country settings
Check that yours are the same as in week_planning
Thanks so much for the quick replies!
The field [Week] (imported as [Week_Planning]) just contains a date in the format DD-MM-YYYY. (e.g. 03-09-2012).
From all your replies, I have tried adding:
- WHERE [Week_Planning] >= Date(Today());
- where ([Week_Planning])>= date()
- WHERE [Week_Planning] >= Today()
But I always get syntax errors.
The date format set at the beginning of the script is:
I add the 'where' statement after the FROM statement, that is correct right? For example:
[Week] as [Week_Planning],
[ProjectID] as [ProjectID_Planning],
[PlanningID] as [PlanningID_Planning],
[PersonnelID] as [EmployeeNumber_Planning],
[Hours] as [Hours_Planning]
WHERE [Week_Planning] >= Date(Today());
Thanks again for any help, of you need additional information, just let me know.
You have two options
1/ Use the preceding load, which will enable you to use the QlikView functionality
Where Date > Today()
SQL SELECT *
2/ add the where clause in the SQL and use Access functionality. Access syntax requires a lot of brackets see below example
SQL SELECT *