I am looking to convert the following time to UTC format:
Ultimately i am looking to convert the above format to work week of the year with Monday as start day.
Any help is appreciated.
If your problem is resolved, then please click the "Accept as Solution" button to help future readers.
View solution in original post
Thanks a lot. It worked!
To convert the time to the time zone of the Splunk server, use this. Splunk will display the result in your selected time zone.
| eval time=strptime (field, "%m/%d/%Y%H:%M%p%:z")
To display the week number, try this.
| eval ww=strftime(time,"%V")
The %V formatter is for calendar weeks starting on Sunday. Splunk offers no option for different starting days, but this should fill your requirements.