# Convert Date and Time to Zulu
**URL:** https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471
**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:** 20
**Page:** 1
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 5:50pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/1 "2021-03-18T17:50:19Z")
Is there a math formula I can enter into a math column to convert a standard date and time column into Zulu date and time?
Thanks!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2021, 5:55pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/2 "2021-03-18T17:55:26Z")
As I understand it, dates entered will always be in the local time of the user device that entered them. So to convert to GMT/Z, you would first need to know the time zone of the user, and then add or subtract the appropriate number of hours.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 5:58pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/3 "2021-03-18T17:58:25Z")
Hmm most folks will be on Eastern US time. I’m using this for an add to calendar function, it needs zulu time to add to calendar properly.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2021, 6:06pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/4 "2021-03-18T18:06:07Z")
US East is GMT -4
So you should just be able to do ‘date + 4/24’
PS. I’m on my phone right now, so I haven’t tested that. But I think it should be right. I’m sure Jeff will correct me if it’s not 😉
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 6:14pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/5 "2021-03-18T18:14:24Z")
Ah let me try…this works for date AND time? This is how I currently have the standard date and time:
Did it, but it doesn’t look right, thought it has to be in this format:
`2016-05-26T15:00:00Z`
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2021, 6:20pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/6 "2021-03-18T18:20:13Z")
Yes, just put that formula in a math column and replace ‘date’ with the date/time column that you want to convert.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 6:22pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/7 "2021-03-18T18:22:54Z")
You can see in the top right how it displays:
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2021, 6:26pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/8 "2021-03-18T18:26:41Z")
> [@Jen\_NYCP](#):
>
> Did it, but it doesn’t look right, thought it has to be in this format:
> `2016-05-26T15:00:00Z`
That’s just an ISO 8601 representation of the date/time.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 6:35pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/9 "2021-03-18T18:35:27Z")
When I add the event to calendar its giving me 1969 as year
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 18, 2021, 7:24pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/10 "2021-03-18T19:24:06Z")
You’ll either have to split each component of the date out into separate columns and piece them together, or for something to try, create an IF Then column. Set it up so if date is not empty then return date. For the else, point it to any text column. This usually works to remove formatting from a number column, so hopefully it works for date too.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 8:45pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/11 "2021-03-18T20:45:18Z")
> [@Jeff\_Hager](#):
>
> You’ll either have to split each component of the date out into separate columns and piece them together,
So the the date and time should be seperate?
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 18, 2021, 8:46pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/12 "2021-03-18T20:46:41Z")
> [@Darren\_Murphy](#):
>
> That’s just an ISO 8601 representation of the date/time.
No idea what that means…
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 18, 2021, 9:08pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/13 "2021-03-18T21:08:08Z")
You can use date math such as year(date), month(date), hour(date), etc to deconstruct the individual parts of a date. Then you can reconstruct the individual parts into your zulu/iso date format.
But I would seriously try the trick with the IF column first. The else has to be a text based column.
@Darren_Murphy if you noticed Jen’s other posts, she’s trying to get the iso format to construct a url that requires it.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2021, 11:57pm UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/14 "2021-03-18T23:57:19Z")
> [@Jeff\_Hager](#):
>
> @Darren_Murphy if you noticed Jen’s other posts, she’s trying to get the iso format to construct a url that requires it.
Yeah I noticed those just before I crashed 💤💤💤
Was too late and was too tired to venture any further down the rabbit hole at that point…
Jen - did you manage to get the format you need by using Jeff’s suggestion?
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 19, 2021, 4:04am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/16 "2021-03-19T04:04:17Z")
Got it! Somehow that logic works…no idea how…ha. It’s displaying correctly in the Glide data editor but when I add it to calendar no its a few ours off instead of 3-5pm its adding the event from 11am-1pm.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 19, 2021, 4:28am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/17 "2021-03-19T04:28:05Z")
Almost!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 19, 2021, 4:29am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/18 "2021-03-19T04:29:52Z")
Did you do the date math before converting it to the ISO format?
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 19, 2021, 4:31am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/19 "2021-03-19T04:31:59Z")
It sounded like that was a seperate method.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 19, 2021, 4:33am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/20 "2021-03-19T04:33:14Z")
The date math converts to GMT time, and then Jeff’s idea applies the correct format. So you need to do both.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [March 19, 2021, 4:42am UTC](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/21 "2021-03-19T04:42:12Z")
I added in the math date/time but it doesnt apply the format correctly, as you can see in the first column. The second column is straight from the regular date/time column.
[Next page](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471.md?page=2)