Splunk Search

need to add 45 days in a field

Path Finder

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

Labels (1)
Tags (1)
0 Karma
1 Solution

Super Champion

@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")

View solution in original post

Super Champion

@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")

View solution in original post

Path Finder

perfect, it worked.
thanks

0 Karma

Super Champion

Please accept answer to help future readers.

0 Karma

Path Finder

done
thanks again

0 Karma