# Convert Date and Time to Zulu **URL:** \ **Category:** Ask for Help\ **Created:** [March 18, 2021, 5:50pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471 "2021-03-18T17:50:19Z")\ **Posts on this page:** 16\ **Page:** 2
**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:** [March 19, 2021, 4:47am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/22 "2021-03-19T04:47:17Z")
Sorry, I’m a bit lost. Your screen shot appears to be showing a _start_ time in the first column, and then an ISO formatted _end_ time in the second column. Are you expecting the start time and end time to be the same? What are the original start and end times? It should be: - Original Start Time → Date Math to Convert to GMT → Formatting logic provided by Jeff to apply ISO formatting - Ditto for End Time ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 19, 2021, 4:50am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/23 "2021-03-19T04:50:57Z")
Orginal Date and Time ![cal2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea1ce20e61ab398ec6c6ff64d5306d31fd05cf34.png) Math Date and Time ![cal23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b279f29947814b3b079c9760d961a9d43def77a.png) 1st column If then else Math Date and Time 2nd column If then else Orginal Date and Time _Just to show the difference_ ![cal234](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9d5a41c3d1ab5ec3c2117c3660c2418f846d3ef.png) ---
**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:** [March 19, 2021, 4:54am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/24 "2021-03-19T04:54:18Z")
Okay, so it looks like Jeff’s trick isn’t working when being applied to the result of the math column. Give me a little while to have a play with this. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 19, 2021, 4:59am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/25 "2021-03-19T04:59:28Z")
Let me see if the math time/date works by itself. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 19, 2021, 5:02am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/26 "2021-03-19T05:02:21Z")
This seems the work!! When I add to calendar it’s the correct date and time. So doesn’t need to be ‘displayed’ as Zulu format it looks like. Thank you! ---
**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:** [March 19, 2021, 5:05am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/27 "2021-03-19T05:05:09Z")
🤣 Well, that’s a relief! I just started testing and couldn’t get Jeff’s trick to work, so I was about to suggest plan B, which would have involved splitting the dates into parts and reconstructing using a template column - which would have meant _lots_ of extra columns 😱 ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 19, 2021, 5:06am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/28 "2021-03-19T05:06:35Z")
Don’t want that 😄 ---
**Author:** ![CH310401](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ch310401/32/43293_2.png) [@CH310401](https://community.glideapps.com/u/CH310401)\ **Post date:** [May 30, 2022, 12:46pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/29 "2022-05-30T12:46:54Z")
Using the MATH column no longer seems to work as a technique for grabbing the ISO format of the date/time stamp. How can I display the ISO format that is “behind” the display datime/time stamp in a Glide sheet column? ---
**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:** [May 30, 2022, 1:37pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/30 "2022-05-30T13:37:39Z")
What happens if you change the column type to text instead of date? ---
**Author:** ![CH310401](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ch310401/32/43293_2.png) [@CH310401](https://community.glideapps.com/u/CH310401)\ **Post date:** [May 30, 2022, 2:25pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/31 "2022-05-30T14:25:29Z")
It just converts it to text, but still not in the ISO format ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97da3da8f03fffdfb14e97e1a65511f307b41f09.png) ---
**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:** [May 30, 2022, 3:11pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/32 "2022-05-30T15:11:12Z")
Ok, so I assume this is a Glide Table instead of a google sheet? ISO is stored in Google sheets as text, but I think it’s slightly different with glide tables and it’s stored as a date in the database. In that case, you may have to manually build it out using several math columns to split out the parts and a template column to join it together, or a javascript column to take in a date and return the ISO format, or a Format Date column to possibly return an ISO format. I can’t think of another way to get ISO if you aren’t using a google sheet. ---
**Author:** ![CH310401](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ch310401/32/43293_2.png) [@CH310401](https://community.glideapps.com/u/CH310401)\ **Post date:** [May 30, 2022, 5:44pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/33 "2022-05-30T17:44:45Z")
Thanks, Jeff. Really appreciate that. I’ll tinker with those options and see if I can get it. Thank you. ---
**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:** [May 30, 2022, 11:37pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/34 "2022-05-30T23:37:52Z")
@Jeff_Hager I just figured this out recently, You can do it by using a JavaScript column and returning the column itself. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/77b363615af4377d99750ecf17f2f05f4aacb2aa.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c954f2fb616967cb464fe07de99ce1a43c67af68.png) ---
**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:** [May 31, 2022, 3:58am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/35 "2022-05-31T03:58:24Z")
Well that’s easy! ---
**Author:** ![CH310401](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ch310401/32/43293_2.png) [@CH310401](https://community.glideapps.com/u/CH310401)\ **Post date:** [May 31, 2022, 10:53am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/36 "2022-05-31T10:53:46Z")
This is really terrific, @ThinhDinh ! Thanks to both of you! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/37 "2024-01-17T16:49:36Z")
Closed on January 17, 2024, 4:49pm UTC [Previous page](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471.md?page=1)