active and set value to current date and time

  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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?
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Does "LAST_QUARTER" not work?
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
But do I have to set a "Value" so it know what date from which to calculate "Last Quarter"
Photo of Peter Hale

Peter Hale, Employee

  • 330 Points 250 badge 2x thumb
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.
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Right, so instead of the "Activate and Set Value" action, just use the "Activate" action.