I forgot to mention that I allready have the date in both integer and true date format in load. Sorry.
Still I am not sure how this helps me. Please forgive me if I have misread your reply.
Look at one line of my base table
customer, order, item, qty, day, FromDate, ToDate
(Fromdate/todate is true dateformat)
If my user now ask for any customer with recuring order for year 2010 week 49 the above line should apear. If I use the date field in the spesific line It would be year 2010, week 1. It should recognize the above line and place it in week 49, since the selected period is between the from and to date.
now I know a litte bit more. But this I could have known earlier if I had read your first post more carefully, sorry!
Your users want to specify a week and then all rows should appear in your (straight) table with the selected week between fromdate and todate. For this purpose I would use a variable event trigger. Let me introduce this proceeding with a date value instead of a week. With a week value it works of course as well. First you define a variable. Next you define a Variable Event Trigger (settings --> document prop --> trigger --> Button "OnInput") with two selection actions. First action selects the according selection for the FromDate (with a searchstring like
='<=' & vDate & ' >=01.01.2010' ).
Second action defines the selection for the ToDate. When using an input box for your variable the trigger should fire (= execute the actions) and your two dates (and the according rows) should be selected.
As far as I remember SET Analysis was introduced in 8.5. (the Triggers above did come later). You should be able to use the term above in your expression. Note that the value of the second date "23.03.2011" is for my testing only. Change it to a proper val i.e. "999999".
One hint: In V9 (I am currently using a stable version QV9SR6) and in the brandnew V10 there are a lot of new features. Think about an update!