one of the fields is an endtime of a task, represended by HH:mm:ss.nnn
the model is working fine.
running with 11.2 sr9 on win7 32 bit.
the customer requested an ability to range a time windows of a hour,
thus i have created a variable of a starttime, and created a query in an advanced search over the endtime field:
=[EndTime]>=mid($(starttime),1,2)&':'&mid($(start),3,2)&'*' and [EndTime]<=mid($(starttime),1,2)+1&':'&mid($(start),3,2)&'*'
the input variable gets a number, like 1445, and the query dissolve the input and combine like:
=[EndTime]>=14:45* and [EndTime]<=15:45*@
the query runs fine, but each time i change the starttime variable value, and run the adv search (on GO botton), nothing happend. i need first to do a 'clear all' and the run the query again to get result.
further, when the query runs and after i bookmark the result, when i try to activate the created bookmark, i get different results.
is it a bug in the version or i do something wrong?
