Skip to main content

How Do I get the Upcoming Date from a Date field

  • July 18, 2022
  • 3 replies
  • 27 views
O

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

Kamille_Parks11
Forum|alt.badge.img+27

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"
)
O
  • Official_Andre
  • Author
  • New Participant
  • 1 reply
  • July 18, 2022

Thank you Kamille.

To explain better what I want to do,

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.

Kamille_Parks11
Forum|alt.badge.img+27

Thank you Kamille.

To explain better what I want to do,

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.


Terms & ConditionsAccessibility statement