# Input Format for Text to Date computed column to output the correct time **URL:** \ **Category:** Ask for Help\ **Tags:** date-math, tutorial, computed-columns\ **Created:** [September 22, 2025, 10:25pm UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548 "2025-09-22T22:25:43Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [September 22, 2025, 10:25pm UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/1 "2025-09-22T22:25:43Z")
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: 1. YEAR(D)\*10^4+MONTH(D)\*10^2+DAY(D) 2. YEAR(D)\*100000000 + MONTH(D)\*1000000 + DAY(D)\*10000 + HOUR(D)\*100 + MINUTE(D) Any ideas? ---
**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:** [September 22, 2025, 11:23pm UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/2 "2025-09-22T23:23:42Z")
It works for me when I include an offset which is the reverse of my actual offset. I am UTC+8, so I enter `utc-8` and that gives me the correct result. Don’t ask me why 🤷‍♂️ ![CleanShot 2025-09-23 at 07.24.18@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/69c26322873da69f4e798a09a71e7c9deb29ceba.png) ---
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [September 23, 2025, 12:12am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/3 "2025-09-23T00:12:07Z")
hmm ok. I’ll try something similar. Thanks! Which math date formula do you use for the input? ---
**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:** [September 23, 2025, 12:18am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/4 "2025-09-23T00:18:30Z")
Similar to yours, except without the Hours, Minutes & Seconds (because in my example I needed it anchored to midnight). ---
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [September 23, 2025, 12:41am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/5 "2025-09-23T00:41:19Z")
mine still won’t accept the hours and minutes math version, it only accepts the shorter 8-digit input. With the shorter version like what you are using, I can block-shift the time but it doesn’t pick up the individual times. I would like it to show up like this… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fce288230bebe03da706048541dcce4fb104cd1a.png) instead of this ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/092235fb3737e50c1a8bdbf9a5fd53e707a8c698.png) ---
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [September 23, 2025, 1:03am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/6 "2025-09-23T01:03:53Z")
I’ve seen advice on the forum that the math calculated dates are more reliable, that’s why I was hoping for a math output I can use in the Text to Date column that would honor the specific times for each item on the schedule. ---
**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:** [September 24, 2025, 12:53am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/7 "2025-09-24T00:53:26Z")
> [@Sekayi\_Liburd](#): > > mine still won’t accept the hours and minutes math version, it only accepts the shorter 8-digit input. ![CleanShot 2025-09-24 at 07.52.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6ed9ebe250bd7498fa1ee32b3f7ddd9907abb28.png) I think you have to specify the format `yyyyLLddHHmmss`. But like Darren said, I have to use the timezone that is opposite to mine to get the right output. Seems like a bug. ---
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [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/8 "2025-09-24T03:47:31Z")
Oh perfect!! Thanks @ThinhDinh When I used yyyyLLddHHmm to format it, it worked!! And I used utc+4 which is the inverse for my zone, hahaha. Thanks to you both for your help 😊 ---
**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:** [October 1, 2025, 3:47am UTC](https://community.glideapps.com/t/input-format-for-text-to-date-computed-column-to-output-the-correct-time/84548/9 "2025-10-01T03:47:49Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.