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

[ibob0304]

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.

[Vijeta · Accepted solution]

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

[ibob0304]

Tried 60*24*60 and it worked.,

[Vijeta]

yes sorry missed the * while typing