Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sub firstSel
Set q = ActiveDocument
q.ClearAll (True)
Set f1=q.GetField("AV_FLOW_YEAR")
f1.select("2011")
Set f2=q.GetField("AV_FLOW_MONTH")
f2.select("09")
Set f3=q.GetField("DAY")
f3.select(">=1 <="&datepart("d",now()))
'would like to set range to be >=1 <=today()
End sub
Looks like I found the answer, by using the & to append the value to the string expression used for the search criteria
Sub firstSel
Set q = ActiveDocument
q.ClearAll (True)
Set f1=q.GetField("AV_FLOW_YEAR")
f1.select("2011")
Set f2=q.GetField("AV_FLOW_MONTH")
f2.select("09")
Set f3=q.GetField("DAY")
f3.select(">=1 <="&datepart("d",now()))
'would like to set range to be >=1 <=today()
End sub
Looks like I found the answer, by using the & to append the value to the string expression used for the search criteria