Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How Do I get the Upcoming Date from a Date field

Topic Labels: Dates & Timezones
286 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi guys,
I currently have an Events table that shows all my Events with their Name fields and Date Fields.
I need in my case to set status for each of the Event - DONE, UPCOMING, LATER. How best can I achieve this. Most of the formula’s I have tried are not giving me the required solutions.

3 Replies 3

Since you didn’t define what you consider “upcoming” vs “later”, here’s the general idea.

IF(
  {Date Field},
  IF(
    {Date Field} < TODAY(),
    "DONE",
    IF(
      DATETIME_DIFF({Date Field}, TODAY(), "days") < 8,
      "UPCOMING",
      "LATER"
    )
  ),
  "No Date"
)

Thank you Kamille.

To explain better what I want to do,
Airtable 01
So above are the list of my date. I want to create a status field that knows when the nearest future date to the todays date is set to as Upcoming, while further future date is set to as later and then past dates set to as Done events.

As you can see the next event should be on the 21st of July 2022.
Grinding hard to get the right formula but is just not working out yet.

You can’t compare dates across rows that aren’t linked. If the 7/21 record is not linked to the 8/4 record in some way, there is no way for Airtable to compare those two dates with a formula to determine that 7/21 is the upcoming one.