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

[samlinsongguo]

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

[amiftah · Accepted solution]

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

[FrankVl]

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

[samlinsongguo]

thank you for your help