Time Picker in dbxquery BETWEEN SQL clause

Dashboards & Visualizations

HI Guys - relative newbie, so apologise if this has been answered, I did look around, but couldn't find anything.

I have built a dashboard, it has a time input that generated values like: earliest = -15m to latest = now, how can I turn these into SQL compatible data types so that when I execute:

| dbxquery query="SELECT * FROM tableName WHERE created BETWEEN $LATEST$ AND $EARLIEST$" connection="dbConnectionName"

Where in the illustration above my time picker is: $tok.timeWindow.earliest$ to $tok.timeWindow.latest$

So that the earliest and latest values can sit within a between clause.

Thanks.

Get Updates on the Splunk Community!

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

The Problem: Too Many Alerts, Too Little Context Security operations teams running Splunk Enterprise Security ...

All Work and No Play? Not at .conf26! Unwind at These Evening Events

Between hands-on technical sessions, keynote reveals, and diving into live architectures, .conf26 is packed ...

Join the Hackathon at .conf26 and build a No-Code AI agent

Join us for the AI Agent Buildathon, an in-person, three-hour hands-on Hackathon where you’ll use Splunk Agent ...