Using daterange filter start and end dates in a query

I recently wanted to use the parts of a daterange filter directly in a query. I didn't find this documented, so here it is: use [daterange_start] and [daterange_end]. Example:

datediff('days', greatest(published_at, [daterange_start]), least([daterange_end], sysdate)) as days_live_on_site
1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 1 yr agoLast active
  • 1Replies
  • 606Views
  • 1 Following