Skip to main content

NEED HELP FOR FOLLOW-UP DATE Formula

  • August 15, 2023
  • 1 reply
  • 16 views

Forum|alt.badge.img+1

"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

Forum|alt.badge.img+12
  • Inspiring
  • 30 replies
  • August 15, 2023

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.