i have a field "add_time" with the values as "05-27-2020 08:57:34.024"
i want to create a field which will show 45 days ahead of the given time.
i.e output should be "07-11-2020 08:57:34.024"
please help me in writing this spl.
Thanks in advance
@vinitpathri Try below-
|makeresults|eval add_time="05-27-2020 08:57:34.024"|eval new=strftime(strptime(add_time,"%m-%d-%Y %H:%M:%S.%3N")+3888000,"%m-%d-%Y %H:%M:%S.%3N")
@vinitpathri Try below-
|makeresults|eval add_time="05-27-2020 08:57:34.024"|eval new=strftime(strptime(add_time,"%m-%d-%Y %H:%M:%S.%3N")+3888000,"%m-%d-%Y %H:%M:%S.%3N")
perfect, it worked.
thanks
Please accept answer to help future readers.
done
thanks again