Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Re: Would like to automatically update a date field for followups

76 0
Showing results for 
Search instead for 
Did you mean: 

Very simple, but I couldn’t seem to find it anywhere.

I have a “date contacted” date field, and a “follow up” date field.

I want the “follow up” date field to automatically populate a date that is one week out.

Any help would be greatly appreciated!

2 Replies 2

Rather than using a date field, you could use a formula field. The date functions are documented here, but here’s an example:

Date Contacted (Date)

Follow-up (Formula)

Follow-up’s formula:

    {Date Contacted},
        DATEADD({Date Contacted},1, 'weeks'),

If you’d like to use a pattern other than DD/MM/YYYY, date patterns are documented here.

@Zollie thanks! That’s really helpful :slightly_smiling_face: