active and set value to current date and time

BillBill ✭✭
edited May 12 in Questions
I want to wait to run a query when the tab is selected with a filter of last quarter.  What can put in the value field to use the current date and time?
image

Comments

  • Matt SonesMatt Sones ✭✭
    edited July 2017
    Does "LAST_QUARTER" not work?
  • BillBill ✭✭
    edited May 12
    But do I have to set a "Value" so it know what date from which to calculate "Last Quarter"
  • edited July 2017
    You shouldn't have to, the actual query has LAST_QUARTER in it, so the data coming back will be filtered by the last quarter.
  • Matt SonesMatt Sones ✭✭
    edited July 2017
    Right, so instead of the "Activate and Set Value" action, just use the "Activate" action.
Sign In or Register to comment.