Getting Data In

timestamp

lorscardala985
Explorer

i have a problem with the timestamp when i parsing the data, i want the date to start with 28/04/2023 and end with 03/05/2023 but it start with 30/04 then 29/04 and end with 28/04, who can i start the data with 28/04 and not 30/04

Labels (1)
0 Karma

lorscardala985
Explorer

sc.png

 

 

search4.png

this are my sourcetype and the problem with the date

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

This issue doesn't appear to be with the dates per se, it is that the x-axis is sorted lexicographically (alphabetically) - either change your date format to YYYY/MM/DD or change the search so that the results are sorted by ascend time order.

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @lorscardala985 ,

are you speaking of the parsing phase or the search outputs ?

if in the parsing phase, the date is extracted from the log so there isn't a starting or ending date.

If you're speaking of the search output, you can change the sorting order using the sort command:

<your_search>
| sort _time
| table ...

Ciao.

Giuseppe

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It sounds like the timerange for your search is not correct - how are you setting this?

Also, event usually come back in reverse chronological order (latest first). You can reverse the order with the reverse command or sort command (using _time as the sort variable).

0 Karma
Get Updates on the Splunk Community!

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...

Getting Started with Splunk Artificial Intelligence, Insights for Nonprofits, and ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...