Splunk Search
Highlighted

In a table using CSV data, how do we add "waitdays" to date and show in new column ?

Communicator

I have CSV data like below,

---------------------------------------------------
Date1              |   WaitDays   
---------------------------------------------------
9/24/2018      | 20
8/28/2018      | 160
7/13/2018      | 01

How do we add the waitdays to date and show in new column ?

 | eval inputDate = relative_time(Date1, "%Y-%m-%d")
 | eval expiring = inputDate  + WaitDays
 | eval expiring = strftime(expiring, "%Y-%m-%d")

I tried this, but it is not working as expected.

0 Karma
Highlighted

Re: In a table using CSV data, how do we add "waitdays" to date and show in new column ?

Influencer

Hi,

You can use the below logic for date and waitdays conversion to seconds and then calculating exp date

eval date=strptime(Date1,"%m/%d/%Y")| eval wdays= WaitDays * 60 *24 * 60|eval exp= date + wdays| eval exp=strftime(exp,"%Y/%m/%d")

Thanks
Vijeta

View solution in original post

Highlighted

Re: In a table using CSV data, how do we add "waitdays" to date and show in new column ?

Communicator

Tried 602460 and it worked.,

0 Karma
Highlighted

Re: In a table using CSV data, how do we add "waitdays" to date and show in new column ?

Influencer

yes sorry missed the * while typing

0 Karma