# \#date-math **URL:** https://community.glideapps.com/tag/date-math/11.md [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) --- ## [Input Format for Text to Date computed column to output the correct time](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548)
**Author:** [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Replies:** 7\ **Last updated:** [September 24, 2025, 3:47am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548 "2025-09-24T03:47:31Z")
Hi guys! What is the correct input for a Text to Date computed column to output the correct time of an event? I have tried inputting a math columns that use the following formulas: YEAR(D)\*10^4+MONTH(D)\*10^2+DAY(D) … --- ## [Current date/time in Data column?](https://community.glideapps.com/t/current-date-time-in-data-column/83935)
**Author:** [@prolost](https://community.glideapps.com/u/prolost)\ **Replies:** 4\ **Last updated:** [August 20, 2025, 9:32pm UTC](https://community.glideapps.com/t/current-date-time-in-data-column/83935 "2025-08-20T21:32:20Z")
Is there a way to create a data column with the current date/time at a specific time zone? I have some user actions that move user-specified dates out to the coming Monday or Saturday, and my solution would be less hack… --- ## [📅 Master Date Formatting in Glide – Fix Date Issues & Build Dynamic Calendars!](https://community.glideapps.com/t/master-date-formatting-in-glide-fix-date-issues-build-dynamic-calendars/79943)
**Author:** [@Gideon\_Lahav\_Busines](https://community.glideapps.com/u/Gideon_Lahav_Busines)\ **Replies:** 2\ **Last updated:** [May 5, 2025, 7:34am UTC](https://community.glideapps.com/t/master-date-formatting-in-glide-fix-date-issues-build-dynamic-calendars/79943 "2025-05-05T07:34:09Z")
Hey Gliders! :wave: Are you struggling with date formatting, broken relations, or setting up a daily/monthly calendar in Glide? You’re not alone! Many users, including Maria Lindquist, have asked how to extract only the… --- ## [Convert Duration Format to Decimal](https://community.glideapps.com/t/convert-duration-format-to-decimal/79781)
**Author:** [@Motte](https://community.glideapps.com/u/Motte)\ **Replies:** 5\ **Last updated:** [February 5, 2025, 2:35am UTC](https://community.glideapps.com/t/convert-duration-format-to-decimal/79781 "2025-02-05T02:35:48Z")
I have created a CURRENT DURATION column by subtracting CURRENT START from CURRENT STOP (both are date / time columns) and - as desired - it gives me elapsed hours:minutes:seconds in duration format. So I try to do m… --- ## [Custom component showing different date that what was picked](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121)
**Author:** [@Valeria](https://community.glideapps.com/u/Valeria)\ **Replies:** 15\ **Last updated:** [December 4, 2024, 12:53am UTC](https://community.glideapps.com/t/custom-component-showing-different-date-that-what-was-picked/78121 "2024-12-04T00:53:48Z")
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 whenev… --- ## [Filtering A Check In Date to Show Only Today's Bookings](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872)
**Author:** [@Ben164](https://community.glideapps.com/u/Ben164)\ **Replies:** 2\ **Last updated:** [November 13, 2024, 9:51am UTC](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872 "2024-11-13T09:51:20Z")
Morning, I have been reading a number of previous threads but cannot find a method to approach the below, can anyone help please? I am building a Hotel Booking System and would like to filter the Check in Date of a boo… --- ## [Strange Date/Time behavior](https://community.glideapps.com/t/strange-date-time-behavior/77544)
**Author:** [@Bernd\_Grimm](https://community.glideapps.com/u/Bernd_Grimm)\ **Replies:** 11\ **Last updated:** [November 1, 2024, 5:34pm UTC](https://community.glideapps.com/t/strange-date-time-behavior/77544 "2024-11-01T17:34:36Z")
Hey gliders, I have just noticed a somewhat strange behavior of the date function. I create a data set with a date/time specification via the API. November 1st is “translated” as January 11th. This is probably due to t… --- ## [Add duration to a date time entry to calculate the end time](https://community.glideapps.com/t/add-duration-to-a-date-time-entry-to-calculate-the-end-time/76379)
**Author:** [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Replies:** 1\ **Last updated:** [September 14, 2024, 6:48pm UTC](https://community.glideapps.com/t/add-duration-to-a-date-time-entry-to-calculate-the-end-time/76379 "2024-09-14T18:48:56Z")
I am able to add DAYS easily using a math column to a date-time value but I need to just increment the MINUTES instead. For example a start date of 9/14/24 4:00 PM + 45 minutes duration should produce 9/14/24 4:45 PM a… --- ## [Math Column showing result wrong](https://community.glideapps.com/t/math-column-showing-result-wrong/75202)
**Author:** [@Terence\_Vrugtman](https://community.glideapps.com/u/Terence_Vrugtman)\ **Replies:** 4\ **Last updated:** [July 29, 2024, 7:40pm UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202 "2024-07-29T19:40:41Z")
I have a math column. I am working out a timestamp - Start Time to get the length of time or duration. The app/column keeps showing the format in a date and time format rather than a duration format. All other tables are… --- ## [Query Data that is within a week, month and day from now](https://community.glideapps.com/t/query-data-that-is-within-a-week-month-and-day-from-now/74694)
**Author:** [@Hive\_Admin](https://community.glideapps.com/u/Hive_Admin)\ **Replies:** 2\ **Last updated:** [July 8, 2024, 7:23pm UTC](https://community.glideapps.com/t/query-data-that-is-within-a-week-month-and-day-from-now/74694 "2024-07-08T19:23:51Z")
Hi guys, Ive seen some video’s on date filtering but essentially just want to be able to have the following : I have a table called closed jobs and there is a closed date value in it. I have another Table called Admin … --- ## [How To Get Value of Today Date](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168)
**Author:** [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Replies:** 12\ **Last updated:** [May 8, 2024, 11:22pm UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168 "2024-05-08T23:22:42Z")
How to Get Value of Today Date. Example, today 8 May 2024, I want to get the value 45420. --- ## [Help with Date/Time](https://community.glideapps.com/t/help-with-date-time/71621)
**Author:** [@Myles\_Guevremont](https://community.glideapps.com/u/Myles_Guevremont)\ **Replies:** 7\ **Last updated:** [March 12, 2024, 3:23pm UTC](https://community.glideapps.com/t/help-with-date-time/71621 "2024-03-12T15:23:03Z")
I am working on a simple timecard app for my field technicians. The two schedulers in the office enter time in and time out, and the technicians approve these times in the app. I am having some difficulty with entering/c… --- ## [Calculating remaining days of month](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240)
**Author:** [@samwagner](https://community.glideapps.com/u/samwagner)\ **Replies:** 2\ **Last updated:** [January 30, 2024, 2:23pm UTC](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240 "2024-01-30T14:23:40Z")
Is there a way to calculate the exact number of renaining days in the current month? Examples: Today is 01/30/2024. So the number of full remaining days in January is 1. If today was 02/02/2024, the number would be 27… --- ## [How do i show dates as in my airtable base](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770)
**Author:** [@Scd](https://community.glideapps.com/u/Scd)\ **Replies:** 14\ **Last updated:** [November 17, 2023, 1:19pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770 "2023-11-17T13:19:27Z")
The date is formatted and presented as i’d like in airtable as european DDMMYY but glide app shows it as MMDDYY How can i change this? I even create a formula field in airtable that would output the date in a text forma… --- ## [How can I make Glide read a date as a string?](https://community.glideapps.com/t/how-can-i-make-glide-read-a-date-as-a-string/67523)
**Author:** [@marshru](https://community.glideapps.com/u/marshru)\ **Replies:** 21\ **Last updated:** [November 8, 2023, 11:53pm UTC](https://community.glideapps.com/t/how-can-i-make-glide-read-a-date-as-a-string/67523 "2023-11-08T23:53:26Z")
I’m working on a little app which reads data from an API end-point. I have to do a little messing around to make appropriate time zone adjustments. I originally wanted to keep the adjusted dates in date format so I can f… --- ## [How is data stored by Glide?](https://community.glideapps.com/t/how-is-data-stored-by-glide/63962)
**Author:** [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Replies:** 9\ **Last updated:** [July 16, 2023, 2:42pm UTC](https://community.glideapps.com/t/how-is-data-stored-by-glide/63962 "2023-07-16T14:42:35Z")
Does anyone know how data is actually stored in Glide? Is it always text - which only get’s project this way or that according to a column’s type? Why I am asking: I’m trying to let the user enter a time using two choi…