topic Invalid Date using Job in the UI in Dashboards & Visualizations

Invalid Date using Job in the UI

sangs8788 — Mon, 19 Jul 2021 07:40:50 GMT

I am trying to display the selected start and end time in the UI. I followed particularly the below answer given by you.

https://community.splunk.com/t5/Dashboards-Visualizations/Setting-job-earliestTime-and-job-latestTime-tokens-for-the-date/m-p/345200/highlight/true#M22464

It was working fine but suddenly it stopped saying Invalid Date. We recently had a splunk Upgrade to Version:8.0.4.1. Could it be due to the upgrade? Was there any change. I couldnt narrow down to exact issue.

Here is the code which you have shared

<form> <label>Show Time from Time Picker</label>  <search> <query>| makeresults | addinfo </query> <earliest>$field1.earliest$</earliest> <latest>$field1.latest$</latest> <done> <eval token="tokEarliestTime">strftime(strptime('$job.earliestTime$',"%Y/%m/%dT%H:%M:%S.%3N %p"),"%m/%d/%y %I:%M:%S.%3N %p")</eval> <eval token="tokLatestTime">strftime(strptime('$job.latestTime$',"%Y/%m/%dT%H:%M:%S.%3N %p"),"%m/%d/%y %I:%M:%S.%3N %p")</eval> </done> </search> <fieldset submitButton="false"> <input type="time" token="field1"> <label></label> <default> <earliest>-24h@h</earliest> <latest>now</latest> </default> </input> </fieldset> <row> <panel>  <html> ( $tokEarliestTime$ to $tokLatestTime$) </html> </panel> </row> </form>

Attaching the screenshot of what is shown in the UI. Could you please suggest.

Re: Invalid Date using Job in the UI

diogofgm — Mon, 19 Jul 2021 11:10:23 GMT

Replace the eval lines with this ones:

<eval token="tokEarliestTime">strftime(strptime($job.earliestTime$,"%Y-%m-%dT%H:%M:%S.%3N%z"),"%m/%d/%y %I:%M:%S.%3N %p")</eval> <eval token="tokLatestTime">strftime(strptime($job.latestTime$,"%Y-%m-%dT%H:%M:%S.%3N%z"),"%m/%d/%y %I:%M:%S.%3N %p")</eval>

Also, I'm sad to say that Niket is no longer with us. He passed away last year.

Re: Invalid Date using Job in the UI

sangs8788 — Mon, 19 Jul 2021 11:20:58 GMT

I am so sorry hear that. I didnt know. May his soul rest in peace. Didnt expect

Re: Invalid Date using Job in the UI

sangs8788 — Mon, 19 Jul 2021 11:21:13 GMT

This doesnt work either

Re: Invalid Date using Job in the UI

kamlesh_vaghela — Mon, 19 Jul 2021 11:36:03 GMT

@sangs8788

Try this,

<form> <label>Show Time from Time Picker</label>  <search> <query>| makeresults | addinfo</query> <earliest>$field1.earliest$</earliest> <latest>$field1.latest$</latest> <done> <eval token="tokEarliestTime">strftime($result.info_min_time$,"%Y/%m/%dT%H:%M:%S.%3N %p")</eval> <eval token="tokLatestTime">strftime($result.info_max_time$,"%Y/%m/%dT%H:%M:%S.%3N %p")</eval> </done> </search> <fieldset submitButton="false"> <input type="time" token="field1"> <label></label> <default> <earliest>-24h@h</earliest> <latest>now</latest> </default> </input> </fieldset> <row> <panel>  <html> ( $tokEarliestTime$ to $tokLatestTime$) </html> </panel> </row> </form>

Thanks
KV
▄︻̷̿┻̿═━一 ?

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

Re: Invalid Date using Job in the UI

sangs8788 — Tue, 20 Jul 2021 06:21:37 GMT

This works. Thanks for looking into this.