Modify Date Formula in Tasks Starter Solution
Trying to create a similar adjustable "days till due" inspired by the Due Date field in the "tasks" starter database.
I want the default date to be the day the record is created+ 30 days. Seems simple but everything i try in the calculated value is not working.
The default value that returns todays date is:
If ( IsEmpty ( Self ) ; Get ( CurrentDate ) ; Self )
I think it should be
If ( IsEmpty ( Self ) ; Get ( CurrentDate ) + 30) ; Self ) But can't get this or anything else i have tried to work.
If this field is of type date (not type calculation), and you are specifying this as an auto-enter field option,
It should work exactly as you have posted it.
But it won't change the dates shown in any existing records, only in new records created after you have made this change.