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?
Please search the forum as this question has been answered before.
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.
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