# Date recognize

**URL:** <https://community.glideapps.com/t/date-recognize/2395>\
**Category:** Report a Bug\
**Created:** [November 25, 2019, 6:06pm UTC](https://community.glideapps.com/t/date-recognize/2395 "2019-11-25T18:06:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Voffs](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/voffs/32/879_2.png) [@Voffs](https://community.glideapps.com/u/Voffs)\
**Post date:** [November 25, 2019, 6:06pm UTC](https://community.glideapps.com/t/date-recognize/2395/1 "2019-11-25T18:06:12Z")

</div>

The calendar recognizes the date obtained by the Today () formula incorrectly by swapping the month and day ☹  
in the example, instead of 01.12, the calendar shows 12.01

 ![BUG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d27355944a7cf8745459c523f44f2262513725b7.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 25, 2019, 11:18pm UTC](https://community.glideapps.com/t/date-recognize/2395/2 "2019-11-25T23:18:27Z")

</div>

Can you help me with the translation of your date value. Is it something like Friday 1 November 2019? If so, it looks like you have have changed the column formatting in the sheet. I usually have better luck leaving the column formatting alone and then creating a new column that uses `=Text(A1, "YYYYMMDD")` or however you would translate. Basically reformatting the date to Year, Month, Day format. I think Glide works best if it can see the date as year/month/day or month/day/year. I think year/month/day is just easier for everybody to understand worldwide.