Triggers on open

[rdsuperlike]

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.

[Anonymous · Accepted solution]

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)