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
Try this: | eval deadline= relative_time(_time, "-1w@w1") | convert ctime(deadline)
Try this: | eval deadline= relative_time(_time, "-1w@w1") | convert ctime(deadline)
I'd suggest using now()
instead of _time
.
thank you for your help