Getting Data In

How can I have the query show just Year-Month-Day and remove the rest of what is showing above?

queryboy
Explorer

I am creating a dashboard for reporting and one of the values of my search is called 'start date' when I check the column of 'start date' in the Search app it shows the date format like this 2022-07-10 which is what I want.

 

When I put the Query into a Splunk dashboard the field value shows like this for all values in the column.

2022-07-10t18:00:00-06:00

Question: How can I have the query show just Year-Month-Day and remove the rest of what is showing above?

 

Labels (1)
0 Karma

johnhuang
Motivator

Assuming the fieldname is "start date":

| eval "start date"=SUBSTR('start date', 0, 10)

 

Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...