date and time conversion

[archanas]

hi,

 I am looking to convert the following time to UTC format:

8/26/20203:47PM-06:00 

Ultimately i am looking to convert the above format to work week of the year with Monday as start day.

Any help is appreciated.

[archanas]

Thanks a lot. It worked! 

[richgalloway · Accepted solution]

If your problem is resolved, then please click the "Accept as Solution" button to help future readers.

[richgalloway]

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.