Help

Would like to automatically update a date field for followups

Topic Labels: Dates & Timezones
1097 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Walker
6 - Interface Innovator
6 - Interface Innovator

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!

3 Replies 3
Zollie
10 - Mercury
10 - Mercury

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.

Thomas_Walker
6 - Interface Innovator
6 - Interface Innovator

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

angel0936491749
4 - Data Explorer
4 - Data Explorer

Just want to ask! I successfully calculate the date. However, airtable said the result isn't present as a date form, so I can not produce a calender accordingly. Would you give some advice!