# Wrong Date/Time formatting (with Zapier) **URL:** \ **Category:** Ask for Help\ **Created:** [April 15, 2020, 12:13pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091 "2020-04-15T12:13:57Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 12:13pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/1 "2020-04-15T12:13:57Z")
Hey everyone! Need some help with formatting date/time. I’m building an events app and as a workaround, I’ve decided to use Zapier to connect Glide with my company’s slack for events to be announced to everyone. All other values I want to be included in the message works fine except the date and time. It’s always in this format: 2020-04-15T11:30:00.000Z. This is despite me using Formatter to convert the value to what I need. This is how the message pops up in Slack: ![Screenshot 2020-04-15 at 12.51.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c53d171c4da52f493368b832ed8100b7efb67611.jpeg) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [April 15, 2020, 12:21pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/2 "2020-04-15T12:21:29Z")
Looks like a time zone issue. ---
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 12:24pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/3 "2020-04-15T12:24:24Z")
How do I fix that? This is what the date looks like in Glide (highlighted): ![Screenshot 2020-04-15 at 13.03.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d63c574708b009436e4e7ea1dae6554ec5903119.png) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [April 15, 2020, 12:25pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/4 "2020-04-15T12:25:43Z")
I am sorry, but can you clarify what exactly is your issue? Is it the difference in time (10:00 and 11:30) or the fact that it is formatted with a T and a Z? ---
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 12:31pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/5 "2020-04-15T12:31:40Z")
My apologies for not being clear. I’m building an events app where users can send event invitations to Slack (via Zapier). All the other values come out correctly, except the date and time. The date currently is formatted as 2020-04-15T11:30:00.000Z. I would like the date and time to be formatted as DD/MM/YYYY HH:mm when it shows up on Slack. Here is the message currently: ![Screenshot 2020-04-15 at 12.51.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c53d171c4da52f493368b832ed8100b7efb67611.jpeg) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [April 15, 2020, 12:32pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/6 "2020-04-15T12:32:56Z")
You have to format it in Zapier using Formatter. ---
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 12:34pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/7 "2020-04-15T12:34:21Z")
I have: ![Screenshot 2020-04-15 at 12.49.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7e20bcfcb03a5ea3c77f53fd791b8aeeb137f34f.png) ---
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 12:36pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/8 "2020-04-15T12:36:09Z")
Is this the correct order?: ![Screenshot 2020-04-15 at 12.48.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/179ad038e6018fb2481683adfa86249d5c4448d0.png) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [April 15, 2020, 1:07pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/9 "2020-04-15T13:07:14Z")
The order is correct. Did you run the Test in step 2? Switch on this ZAP and run another test. ---
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 1:51pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/10 "2020-04-15T13:51:18Z")
Update: I have found out the issue. Turns out I had to change the value in the ‘Message Text’ field from the Glide Value 2 to the Formatter Value 2 that I created in Step 2. All this time I was wrongly using Value 2 from Glide. See below. ![Screenshot 2020-04-15 at 14.46.28](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b54116ee32dde1dfc49d6220983a08af4e6b4dee.png) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [April 15, 2020, 1:52pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/11 "2020-04-15T13:52:47Z")
That’s right. You never showed the details of the 3rd step in your ZAP. 🙂 ---
**Author:** ![Nouhou\_Basekonda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nouhou_basekonda/32/4861_2.png) [@Nouhou\_Basekonda](https://community.glideapps.com/u/Nouhou_Basekonda)\ **Post date:** [April 15, 2020, 1:59pm UTC](https://community.glideapps.com/t/wrong-date-time-formatting-with-zapier/7091/12 "2020-04-15T13:59:07Z")
My fault 😄 Thanks for your help.