Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking for a way to use a select. macro to select a certain range of date.
in the attached qvw it's picking up the 201002 period, but I would like to have a formula which is always using >200906 and <= ( content of a variable which is giving back the content of the field LastYearMonth ( or the variable V1)
I tried but couldn't get it to work, has anyone an idea?
any help is appreciated!
Linda Monincx
hi Linda,
try this:
sub period
Last = ActiveDocument.Variables("v1").GetContent.String
First = "200906"
mySelect= ">" & First & " <" & Last
ActiveDocument.Fields("YearMonth").Select mySelect
end sub
Alex
hi Linda,
try this:
sub period
Last = ActiveDocument.Variables("v1").GetContent.String
First = "200906"
mySelect= ">" & First & " <" & Last
ActiveDocument.Fields("YearMonth").Select mySelect
end sub
Alex
HI Alex,
Many thanks that was the syntax i was looking for
Kind regards,
Linda Monincx