i wonder if its possible to select a value in a field, but instead using the field's value, use an expression that calculates the desired value to be selected...so instead of:
.doc.Fields("Year Quarter").Select "2016Q3"
do something like this:
.doc.Fields("Year Quarter").Select "=(Year(addmonths(vToday,-3))&'Q'&Num(Ceil(Num(Month(addmonths(vToday,-3)))/3)) )"
Any advise ?
PS I should mention that i do not want to use a variable that might contain the desired value...