Skip to main content

Hello, I inherited an Airtable base that essential keeps track of new subscribers. It was set up to calculate the enrollment date (ex: 7/24/2025) and extrapolate the year registered into a new column. However, currently the column mostly remains blank and/or it has enrolled everyone in the year 2022. This information is then supposed to be reflected on another table with their information. I am new to using Airtable and any information or direct you can provide is greatly appreciated on how to input an effective dynamic date formula. 

Could you provide a screenshot with some example data and what you’d want the output to be?

A requested here is a screenshot of how it shows up on the base. 

This a screenshot of someone who just joined it shows no date for year or the enrollment date

 

 

Just to elaborate, we kind of need to know how the enrollment date is calculated and how the bad column is set up.

Assuming the enrollment date function is properly working and results in a date string, you should just need a formula field with the formula DATETIME_FORMAT({ENROLLMENTDATEFIELD}, ‘YYYY’) which will strip out the date and just leave 2025. 

Since your new to Airtable, I’ll also recommend the Formula Playground base that Airtable created years back, which is an extremely handy reference to the various formulas you can utilize

 

Well dang, I just posted my first reply as you were uploading this one 😶

Unless there are automations running in the background then everything is just being manually entered here. 

To help automate stuff you’ve got a couple options…

  • Your "Start Date” field can become a created on field if that’s appropriate, so it’ll provide the date the record was created.
  • Your “Start Date” field could be a last modified time predicated on Status, or you could create an automation that fills in the Start Date field with the day Status is changed to “Active” (in fact that could actually be happening just from the screenshots you’ve showed, have you tried flipping the status on the blank one to “Active”?)
  • You should probably just change the # field for Year Registered to a formula field with formula I already mentioned DATETIME_FORMAT({Start Date}, ‘YYYY’). 

EDIT: Weird, I posted initially and got a “moderator approval pending” message but then this one went right up. Anyhow...

Yeah, seconding using a formula for this instead.  DATETIME_FORMAT works, and you could also try YEAR()

Might also want to check if Date is empty too, so it looks like this:

 

IF(
  Date,
  YEAR(Date)
)

 

Terms & Conditions