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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...

SplunkTrust Application Period is Officially OPEN!

It's that time, folks! The application/nomination period for the 2026-2027 SplunkTrust is officially open. If ...