Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
You can use the below search expression:
='>'&Date(Max(DATE)-3, 'YYYYMMDD')
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.