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!

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

Observability Newsletter Highlights | March 2023

 March 2023 | Check out the latest and greatestSplunk APM's New Tag Filter ExperienceSplunk APM has updated ...

Security Newsletter Updates | March 2023

 March 2023 | Check out the latest and greatestUnify Your Security Operations with Splunk Mission Control The ...