Hello,
I am trying to set a relevance trigger for a scheduled web report. I want to automate it to trigger every month on the third tuesday (actually I need to do multiple reports on various days, but this example will cover all them), at a specific time.
I started to pose this question, then figured it out, so I thought I would share…
This relevance worked with WebReports to trigger the report at two different times using the “when relevance becomes true” option:
((now - ((first tuesday of (month_and_year of current date)+14day) as string & " " & “14:12:00”) as local time > 1minute) and (now - ((first tuesday of (month_and_year of current date)+14day) as string & " " & “14:12:00”) as local time < 5minute)) or ((now - ((first tuesday of (month_and_year of current date)+14day) as string & " " & “14:25:00”) as local time > 1minute) and (now - ((first tuesday of (month_and_year of current date)+14day) as string & " " & “14:25:00”) as local time < 5minute))