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!

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 ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...