get a future date added to a field after entering a date in a separate field

Ed N

New Member
I have a training program that when I enter the current date i would like the future date (one year later) to appear in another filed and of course have it saved when I submit the record.
 

Dan Peluso

Member
Staff member
Hi Ed,

So, you can do this with the following settings below.

1. Define a field as Date Time and a formatter of yyy-MM-dd.
2. Define a 2nd field as NUMBER and place the default value of 365 in this field. You could evne make it read only
3. Define a 3rd field as Date Time and also make it a Calculated field.
3a. Configure the calc function to be ADD and add the 2 fields in step 1 and 2. You should also be presented with a UNITS selector in that Calc settings area so that you can define the 365 as representing DAYS as opposed to mins/secs/etc.

I think that should do what you are attempting.

Thanks.
 
Top