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.
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
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
Tried 60*24*60 and it worked.,
yes sorry missed the * while typing