Help

NEED HELP FOR FOLLOW-UP DATE Formula

Topic Labels: Dates & Timezones
630 1
cancel
Showing results for 
Search instead for 
Did you mean: 
angel0936491749
4 - Data Explorer
4 - Data Explorer

"I am conducting research to monitor the depression status of patients. It's crucial that I track their status on a weekly basis. Consequently, I am looking to set up a reminder calendar to facilitate this. I've utilized the provided formula to determine follow-up dates, but Airtable suggests that the outcome isn't recognized as a date format. This has hindered my efforts to create a calendar using the results. I would greatly appreciate any advice on this matter. Thank you!"

 

  IF(
    {First visit},
    DATETIME_FORMAT(
        DATEADD({First visit},1, 'weeks'),
        'MM/DD/YYYY'
    ),
    ""
)
1 Reply 1
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

DATETIME_FORMAT converts it to a string. Just use 

IF({first visit},DATEADD({first visit},1, 'weeks')) and use the formatting tab in the field to make it look the way you want.