Apr 06, 2021 01:31 PM
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!
Apr 06, 2021 02:05 PM
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)
1/1/2021
Follow-up (Formula)
1/8/2021
Follow-up’s formula:
IF( {Date Contacted}, DATETIME_FORMAT( DATEADD({Date Contacted},1, 'weeks'), 'MM/DD/YYYY' ), "" )
If you’d like to use a pattern other than DD/MM/YYYY, date patterns are documented here.
Apr 06, 2021 02:38 PM
@Zollie thanks! That’s really helpful :slightly_smiling_face: