We have two fields one contains a date and one contains a number of days an integer. So we want to add the number of days in the current date and create a new one.
Example :
Date : 6/27/2024
AddDays: 10
output we want 7/7/2024
Please tell how can I implement this in calculated field.
I have done something similar but for years. On ingestion I used set_date_part("yyyy",to_integer(split(warrantyDate,"/")[2])+WarrantyLength,date(warrantyDate, "M/d/yyyy")) to add the warrantyLength int to the year from warrantyDate.
Example:
WarrantyDate = "01/01/2024"
WarrantyLength = 2
the returned value would be 01/01/2026
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.