need to add 45 days in a field

[vinitpathri]

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

[493669 · Accepted solution]

@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]

perfect, it worked.
thanks

[493669]

Please accept answer to help future readers.

[vinitpathri]

done
thanks again