How to insert today + few days in a date field?

#1

Based on the current date how to add (x) days in a date control.

0 Likes

#3

Hi,

You can add days in a date field using DATE & DATESTR functions.
Lets assume, you are accepting date from user in date control with unique name datepicker. Now, copy-paste the below formula in another date control and Save & Validate the formula.
DATE(DATESTR( datepicker , "YYYY"),DATESTR( datepicker , "MM"),DATESTR( datepicker , "DD")+2)
This will add 2 days to the date selected. Similarly, you can add months/years to DATESTR( datepicker , “MM”) & DATESTR( datepicker , “YYYY”) in DATE() function.

You can hide this control and submit it.
Hope, this works for you!

0 Likes