I have set the field to CY2015-Q1 so that I can see it selected on opening the document.
I want it to select itself on it's own at every quarter. eg:- It should change to CY2015-Q2 when the date today is 4/1/2015.
Can I use today() here? any input is appreciated.
I'd rather use ReloadTime() than today(), especially if reload is not every day. Search String will be:
='CY' & year(ReloadTime()) & ' - Q' & ceil(month(ReloadTime())/3)
Retrieving data ...