Variable in Trigger

[QFanatic]

Hi

I have a model that contains a field called Date (that displays YYYYMMDD but us a true date field)

In the on Open Event I want only the last 3 days to be selected, by default.

I have created a variable, vOpenDate, that contains =date(max(DATE) - 3)

how do I implement this in the On Open trigger ? I'm not sure of the syntax...

Thanks

[tresesco]

You can use the below search expression:

='>'&Date(Max(DATE)-3, 'YYYYMMDD')

[NitinK7 · Accepted solution]

hi

you need to create daterange for the same 

1. need to create two variable  for max date and maxdate-2 see below screenshot

2.go to setting -->Document properties-->trigget-->onopen-->add action-->select field

then set your field and write search string like below

='>='&vEnddate&'<='&vStartdate

see below screenshot

Thanks,

Nitin.