# Comparing Date Picker and Airtable dates
**URL:** https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257
**Category:** Questions about Thunkable X
**Created:** [July 16, 2020, 9:35am UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257 "2020-07-16T09:35:54Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [July 16, 2020, 9:35am UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257/1 "2020-07-16T09:35:54Z")
Hi,
I have an AirTable with a date column.
I also have 2 date picker components on my app to choose a date range (Date\_Input1: Start of date range, Date\_Input2: End of date range).
Now when someone picks a date range on the date pickers, I want to check if the AirTable date is within this range and display that data.
I have been trying to do this but facing problems due to date format.
Seems like the 2 cannot be compared since they are in different formats. Can someone help with this plz?
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [July 17, 2020, 12:07pm UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257/2 "2020-07-17T12:07:19Z")
Hey @thestrengthinstitute - I had the same issue recently where I was moving data between Google Sheets and Airtable.
I’m not sure if there was a more elegant solution but I ended up writing a custom function to change between the formats.
Maybe you can change your Airtable settings so the output format matches the Thunkable format?
---
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [July 20, 2020, 10:13am UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257/3 "2020-07-20T10:13:08Z")
Giving this a try but any idea what are the formats I can use?
I don’t mind changing the AirTable date format but not sure which one will match the Thunkable one.
Also would you mind sharing the custom function?
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [July 25, 2020, 1:08pm UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257/4 "2020-07-25T13:08:12Z")
> [@domhnallohanlon](#):
>
> I ended up writing a custom function
@thestrengthinstitute - this was a function in Google sheets, sorry, not a Thunkable function. I only mentioned it was I was dealing with a similar issue with Airtable at the same time.
---
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [August 11, 2020, 8:41pm UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257/5 "2020-08-11T20:41:12Z")
Hi @jane, could you help me with this?
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:26pm UTC](https://community.thunkable.com/t/comparing-date-picker-and-airtable-dates/682257/6 "2024-11-08T12:26:41Z")