Select last week

[#1]

Hi,

I need to automatically select the last Calendar week from my Document to reduce data.

My Field for the Calendar Week is named: cw_iso8601

How can I do this?

Thanks.

[#2 · Accepted solution]

Hi,

Add a action trigger for OnOpen event under Setting->Document Properties->Triggers "Document Event Triggers" section. Add selection in feild action and for field assign the field name "cw_iso8601" and for search string assign the value =Week(Today()-7) .

Please revert back for any further query in this regard.

[#3]

Hi,

In my previous post I had used "Week(Today()-7)" but you can use maximum transaction data like "Week(Max(Date)-7)"

[#4]

Thank you very much! Its working now 🙂