Fields.ToggleSelect not working with date range

Wed, 05 May 2010 01:32:58 GMT

Hello everyone,

I am getting a very weird problem. I have VBScript which will open Qlikview and select some fields based on some criteria then export it to Excel.

One of the field is a date field and it is select as below script.


dim start_of_week
dim current_date, day_of_week
current_date = date()
start_of_week = dateadd("d", -7, current_date) 'COUNT BACK 7 DAYS
objDocument.fields("S/O Action Date").toggleselect ">=" & start_of_week

It is used to work but suddenly this script is no longer working. It is unable to select the date range which is 7 days ago till now. It is selecting everything in "S/O Action Date" field. When I select this field with the same criteria, it is working but not in the script.

Does anyone have this problem before? Any hint to get it work.

Thanks,

Chris

Fields.ToggleSelect not working with date range

m_woolf — Tue, 24 Aug 2010 18:07:10 GMT

Try ActiveDocument in place of ObjDocument

topic Fields.ToggleSelect not working with date range in QlikView

Fields.ToggleSelect not working with date range

Fields.ToggleSelect not working with date range