Difference between two dates

I need to find the difference in days between a date stored in airtable (YYYY-MM-DD) format and current date. Is there any easy way to do this?

1 Like

Please search the forum as this question has been answered before.

1 Like

Thank you. I did search, but the webapi is not working for me. I was wondering if there was a way to calculate the seconds since epoch for airtable and use that.

1 Like

Two different ways to do it.

  • Using the formula in Airtable, create a table with only one row and in that row have 3 columns, first and second columns to enter the date you want using the app. The third column is a formula column to get you the difference between the first two columns.

  • If you find Airtable formulas not very easy, connect the Google sheet and do the same with the sheet which will give you the difference between the two dates.

Thank you. I will try that