# Custom component showing different date that what was picked **URL:** \ **Category:** Report a Bug\ **Tags:** ai, date-math\ **Created:** [November 22, 2024, 1:16am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121 "2024-11-22T01:16:47Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [November 22, 2024, 1:16am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/1 "2024-11-22T01:16:47Z")
I have a date picker and a field in a custom AI component that shows the information that’s on the column where the date picker anotates. I don’t know if it has to do with the AI, with timezones or what issue, but whenever I pick a date it shows another completely different one. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/550618f6499793678b5837da5f4be0c8dbd5bb1f.png) Here’s my date picker ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d9bfb99f493c2bfd22e187fef3b1228664b6c35b.png) Here’s the column it writes to (I have tried both respecting timezones and not doing so) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4c89b78d620a4ad2b71636323159b5c7bd7943ef.png) Here’s the custom component, note that it shows 20 nov 2024, although the column clearly indicates 11/21/2024. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 22, 2024, 1:20am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/2 "2024-11-22T01:20:49Z")
It’s the same date using different display formats. Try adjusting the language/regional settings in your browser. ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [November 22, 2024, 1:26am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/3 "2024-11-22T01:26:35Z")
Sorry I don’t understand, the issue is my browser? What can I do if my clients are the one who use the app and not me? Is there not a way within glide where I can make adjustments so the shown date is exactly what they chose and in their timezone? ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [November 22, 2024, 1:35am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/4 "2024-11-22T01:35:00Z")
Found a solution. I realized that if I used the date picker instead of date and time picker, it always picked the hour at T00:00:00.000Z which is what brought me issues. I added a math column and added 0.2 hours so it would not be in midnight and is now showing the correct date. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 22, 2024, 1:49am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/5 "2024-11-22T01:49:11Z")
> [@Valeria](#): > > Is there not a way within glide where I can make adjustments so the shown date is exactly what they chose and in their timezone? That is exactly what should happen. Dates and times should be shown respecting each users language/regional settings. > [@Valeria](#): > > Found a solution. I realized that if I used the date picker instead of date and time picker, it always picked the hour at T00:00:00.000Z which is what brought me issues. I added a math column and added 0.2 hours so it would not be in midnight and is now showing the correct date. ah, my apologies. I missed that it was showing as two different dates. Question: do you have the “Respect Time Zones” option selected on the date column? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 22, 2024, 2:28am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/6 "2024-11-22T02:28:49Z")
Hola Valeria! As Darren advised you, it is a good practice use “Respect Time Zones” option in your Date column to avoid issues with date/time from several devices. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c24968f471d138e01781758a873f463ac24af3f3.png) I have an AI component similar to yours. I initially had the same problem you describe, but a modification to my prompt fixed it. Here you can see some of my instructions to fix my date/time problem. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/598b13304f86915e4ef0ae6e5ecf429ffae6aff7.png) Saludos! ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [November 23, 2024, 4:02pm UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/7 "2024-11-23T16:02:11Z")
Hi, yes, as I stated previously I tried both using respect time zones and without it and both gave me the same issue. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 24, 2024, 12:27am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/8 "2024-11-24T00:27:07Z")
If you use a normal component to display the date, let’s say a text component, what does it show? ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [November 26, 2024, 3:18am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/9 "2024-11-26T03:18:41Z")
Well I don’t really use this values from glide tables but instead I create a json in glide, call an endpoint and store the values in a database. However, when I display the date from one of the tables of that external database, sometimes it shows the right date, sometimes it shows the previous day and sometimes it shows the next day. It’s an issue I’ve been having and can’t solve yet. As I said, I’ve tried both with and without the option of respecting timezones and in both I get the same issue. Kind of another topic, but while I understand that dates and times are shown respecting each user regional settings, it also brought me many errors back when I used the glide tables. My computer language is in English, but most of my clients have their computers in Spanish. When I stored a date as 10/7/2024 (October 7th), the dates displayed would show my clients July 10th. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 26, 2024, 11:44pm UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/10 "2024-11-26T23:44:28Z")
> [@Valeria](#): > > Well I don’t really use this values from glide tables but instead I create a json in glide, call an endpoint and store the values in a database. What do you mean by “call an endpoint and store the values in a database”? At the end of the day, you would still have it stored somewhere in Glide, right? Is it a datetime column, or a text column where you store the JSON? You mentioned you used a datetime picker, so I thought it’s a datetime column. Hence the suggestion to display it using a text component to see what it shows. ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [November 27, 2024, 5:31pm UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/11 "2024-11-27T17:31:00Z")
I have a Glide table with a date column and other text colums, I create a JSON column to, well, create the JSON that stores all my data. I use an api call to store the values in an external postgreSQL dabatase, which is connected to glide. I do so by calling an endpoint in an action where I pass my JSON data. My external database saves the date in a timestamptz column. The date is then shown on glide in a text component. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 28, 2024, 12:09am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/12 "2024-11-28T00:09:28Z")
So you still have to input the data in Glide, then pass the data to your SQL database, then connect that SQL database to Glide and use it to display on the front end? ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [December 2, 2024, 4:16pm UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/13 "2024-12-02T16:16:13Z")
yup ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 3, 2024, 12:39am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/14 "2024-12-03T00:39:15Z")
Does it at least show correctly on your SQL database’s view? ---
**Author:** ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)\ **Post date:** [December 3, 2024, 2:48pm UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/15 "2024-12-03T14:48:33Z")
yes, everything in my database shows correctly, the issue is when the dates are displayed on glide ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 4, 2024, 12:53am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/16 "2024-12-04T00:53:48Z")
> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2): > > Please note: Glide Support is available with any paid plan. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). (Last updated: 9th May 2024) To create a Support Ticket: Open the App that is giving you problems, and click on the Question mark in the bottom right corner of the builder: Select Get Help: Select Support: [CleanShot 2024-05-09 at 21.10… I would suggest chatting with support to see if it helps. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 2, 2025, 12:54am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121/17 "2025-06-02T00:54:17Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.