Setup Time Filter Document Trigger

[#1]

Hi,

I am trying to setup a document trigger where OnOpen, I want the default filters to be the Current Quarter, Previous Quarter and Same Quarter Last Year.

The Fiscal Quarter format is 201401 - For 1st Quarter of 2014

For any kind of calculations for various time periods, I have creater the Fiscal Quarter counter - FQ_Counter

I setup a document event trigger for OnOpen, Select field: FQ_Counter

Search String:

'(' & $(=Max(FQ_Counter)) & '|' & $(=Max(FQ_Counter)-1) & ')' & '|' & $(=Max(FQ_Counter)-4) & ')'

This doesnt seem to work since the FQ_Counter is not used in a object for user selection.

Not sure, how to achieve this.

Any help, will be appreciated.

Thanks in advance!

Archie

[whiteline]

Hi.

Have you checked your search selection expression using a simple button action ?

[#3]

Hi,

Try with below.

'(' & Date(QuarterStart(max(vDate)),'YYYY-MM') & '|' & Date(QuarterStart(max(vDate),-1),'YYYY-MM') & '|' & Date(QuarterStart(max(vDate),-4),'YYYY-MM') & ')'