# Date fields in Airtable coming through to WeWeb as text

**URL:** <https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481>\
**Category:** Ask us anything\
**Created:** [July 12, 2023, 12:09am UTC](https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481 "2023-07-12T00:09:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mitsley](https://avatars.discourse-cdn.com/v4/letter/m/e99b99/32.png) [@mitsley](https://community.weweb.io/u/mitsley)\
**Post date:** [July 12, 2023, 12:09am UTC](https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481/1 "2023-07-12T00:09:51Z")

</div>

Hi there,

I’m restarting this thread because a previous thread was identified as a WeWeb bug in April, but has gone quiet.

I have some date fields in Airtable that are coming across as text fields in WeWeb:

**Airtable**  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/2/2954d7b45450ce3bda600b0ed2a59b40b721e129.png)

**WeWeb**  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/d/d93ef3b962927300cada4076662d0bfa982a9a8e.png)

It’s a problem in my app, because it means I can’t filter using greater/less than a user-specified date, or do charts with a date axis, or do date sliders. (I have a workaround for the first problem, but not the second two.)

Is there a date field type in WeWeb? Is there a way of using it with Airtable date fields?

Many thanks!

---

<div class="post-metadata">

**Author:** ![gbeaudoin](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/gbeaudoin/32/3221_2.png) [@gbeaudoin](https://community.weweb.io/u/gbeaudoin)\
**Post date:** [July 12, 2023, 1:46am UTC](https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481/2 "2023-07-12T01:46:46Z")

</div>

Dates are basically either strings (like ISO) or integers (timestamps).

In order to use those in functions, you can use WeWeb’s OOTB date functions. Can’t remember the details (on mobile now), but one of them can change it to timestamps if I remember correctly. That would certainly allow you to evaluate dates amongst each other.

---

<div class="post-metadata">

**Author:** ![mitsley](https://avatars.discourse-cdn.com/v4/letter/m/e99b99/32.png) [@mitsley](https://community.weweb.io/u/mitsley)\
**Post date:** [July 12, 2023, 2:43am UTC](https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481/3 "2023-07-12T02:43:40Z")

</div>

Thanks @gbeaudoin

Last time I posted, Quentin said this:

> "It’s indeed an issue on our side. We’re currently looking on how to fix this.
> 
> In the meantime, you could use frontend filters directly on your page by casting back the text data as a date using nocode dates formulas."

I’ve been using that workaround, but it’s quite a lift for things like charts and sliders. I’m hoping the bug gets fixed.

---

<div class="post-metadata">

**Author:** ![mitsley](https://avatars.discourse-cdn.com/v4/letter/m/e99b99/32.png) [@mitsley](https://community.weweb.io/u/mitsley)\
**Post date:** [July 13, 2023, 11:54pm UTC](https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481/4 "2023-07-13T23:54:15Z")

</div>

@aurelie @Quentin do you have any thoughts on this? Please help!

---

<div class="post-metadata">

**Author:** ![Quentin](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/quentin/32/6_2.png) [@Quentin](https://community.weweb.io/u/Quentin)\
**Post date:** [July 17, 2023, 3:05pm UTC](https://community.weweb.io/t/date-fields-in-airtable-coming-through-to-weweb-as-text/3481/5 "2023-07-17T15:05:09Z")

</div>

As @gbeaudoin mentioned, you should treat them as strings or use Airtable formula filters to do this:  
 ![CleanShot 2023-07-17 at 17.04.19](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/1/126b5abcaa11d30204c0114cac19d1bf2ac68fa7.png)

Otherwise, use frontend filters with converted dates.

This is a limitation of the Airtable API, which sends back strings and not timestamps 😕
