This gives me all defects that were last touched on 8/23/2008, regardless of their time.
This only gets me so far; there are two things I wish to do to extend this functionality. They are, in order of importance:
1. to actually change the filter to give me all defects modified since that date (in other words, I would like to change the (=) sign to a (>=) sign). QC does not like it when I do that; it throws this error:
"Property access must assign to the property or use its value."
The data that I find though is inconsistent. In QC customization tab, I'm told that the "Modified" field (BG_VTS) is of a date format. Obviously the field itself takes date time format, and the QC database docs tell me the field is a varchar field with max length 20. Which is it? Depending on the answer to this question, I can probably figure out how to query the field to give me all defects modified since <date>.
2. I would prefer to query against a specific time on a specific day. However, when I attempt to change my code snippet to:
Filter Error in Field < Modified > : In field BG_VTS, the filter condition <2008-08-23 12:43:50 PM> contains spaces. You must encluse the text in quotes, or create a logical expression using AND or OR.
Does anybody have any suggestions on how to set this up so the filter comes out correctly?
Not sure that you can filter based on time but to filter on > you just include > in your filter eg bugFilter.Filter("BG_VTS") = "> 8/23/2008"
A little tip. If you create the filter in the GUI, you can copy and paste it into your code. You just need to remember that if you have " within your filter your vb code will have to look something like
bugFilter.Filter("BG_VTS") = """ & "> 8/23/2008" & """
You don't really need the extra " in this example but it illustrates the point.