Splunk Search

How to give a time value to a field with eval command?

samlinsongguo
Communicator

Hey
I want to create a field with a time value using following commend

| inputlookup task_time_worked.csv | eval deadline=-1week@week

System throw me an error

"Error in 'eval' command: The expression is malformed. "

Any suggestion of what is the right way to write this spl?
Thanks in advance
Regards

0 Karma
1 Solution

amiftah
Communicator

Try this: | eval deadline= relative_time(_time, "-1w@w1") | convert ctime(deadline)

View solution in original post

0 Karma

amiftah
Communicator

Try this: | eval deadline= relative_time(_time, "-1w@w1") | convert ctime(deadline)

0 Karma

FrankVl
Ultra Champion

I'd suggest using now() instead of _time.

0 Karma

samlinsongguo
Communicator

thank you for your help

0 Karma
Get Updates on the Splunk Community!

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...