# Difference between two dates

**URL:** https://community.thunkable.com/t/difference-between-two-dates/1552980
**Category:** Questions about Thunkable X
**Created:** [October 9, 2021, 12:31pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980 "2021-10-09T12:31:42Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![sriram.padmanabhan05](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@sriram.padmanabhan05](https://community.thunkable.com/u/sriram.padmanabhan05)
#### Post date: [October 9, 2021, 12:31pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980/1 "2021-10-09T12:31:42Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![Dean\_Artis](https://avatars.discourse-cdn.com/v4/letter/d/a8b319/32.png) [@Dean\_Artis](https://community.thunkable.com/u/Dean_Artis)
#### Post date: [October 9, 2021, 1:14pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980/2 "2021-10-09T13:14:53Z")

</div>

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

---

<div class="post-metadata">

### Author: ![sriram.padmanabhan05](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@sriram.padmanabhan05](https://community.thunkable.com/u/sriram.padmanabhan05)
#### Post date: [October 9, 2021, 1:18pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980/3 "2021-10-09T13:18:27Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [October 9, 2021, 1:28pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980/4 "2021-10-09T13:28:36Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![sriram.padmanabhan05](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@sriram.padmanabhan05](https://community.thunkable.com/u/sriram.padmanabhan05)
#### Post date: [October 9, 2021, 8:14pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980/5 "2021-10-09T20:14:59Z")

</div>

Thank you. I will try that

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/difference-between-two-dates/1552980/6 "2024-11-08T13:14:56Z")

</div>


