Dashboards & Visualizations

How to convert this date in dropdown in dashboard

supreme_coder
Engager

how do I covert the date that is in dropdown to "Y-M-D". 

I dont want the other stuff next to it (T00:). 

index="main" | eval _time = strptime('close_approach_data{}.close_approach_date', "%Y-%m-%d") | table _time | dedup _time

supreme_coder_1-1612457567723.png

 

Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
      <input type="dropdown" token="datefilter">
        <label>Select Date</label>
        <search>
          <query>index="main" | eval date = strptime('close_approach_data{}.close_approach_date', "%Y-%m-%d") | table date | dedup date | eval showdate=strftime(date, "%Y-%m-%d")</query>
        </search>
        <fieldForLabel>showdate</fieldForLabel>
        <fieldForValue>date</fieldForValue>
      </input>
0 Karma
Get Updates on the Splunk Community!

Dashboard Studio Challenge - Learn New Tricks, Showcase Your Skills, and Win Prizes!

Reimagine what you can do with your dashboards. Dashboard Studio is Splunk’s newest dashboard builder to ...

Introducing Edge Processor: Next Gen Data Transformation

We get it - not only can it take a lot of time, money and resources to get data into Splunk, but it also takes ...

Take the 2021 Splunk Career Survey for $50 in Amazon Cash

Help us learn about how Splunk has impacted your career by taking the 2021 Splunk Career Survey. Last year’s ...