# How to use PARSE\_DATETIME\_TZ()

**URL:** <https://community.tulip.co/t/how-to-use-parse-datetime-tz/447>\
**Category:** General\
**Created:** [June 3, 2020, 12:55pm UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447 "2020-06-03T12:55:21Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [June 3, 2020, 12:55pm UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/1 "2020-06-03T12:55:21Z")

</div>

I like to shorten the App Info.Current Date and Time -function to a special format

Any kind of example is welcome  
Regards  
Christian

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [June 3, 2020, 1:27pm UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/2 "2020-06-03T13:27:41Z")

</div>

Good morning @ChrisF,

Do you need the newly created variable to be in Datetime format? If not, I’d recommend using the FORMAT\_DATE\_TZ function.

For example:

```
format_date_tz(@App Info.Current Date and Time , 'MMM Do YYYY', 'UTC')

```

Here are a couple of screenshot of how this works in an app:

 ![Screen Shot 2020-06-03 at 9.20.48 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/fb8108ce8a6c719ed4ab444fae411325f7c7253e.jpeg)  
 ![Screen Shot 2020-06-03 at 9.20.52 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/87314e8472d5aa1e6b09920fb762def101ddb904.jpeg)

The PARSE\_DATETIME\_TZ() function is typically used to convert from a Datetime \> Text.

Let me know if this helps!

Best,

Giovanni

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [June 8, 2020, 5:38am UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/3 "2020-06-08T05:38:04Z")

</div>

Hi Giovanni,  
i will test it.

Regards Christian

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [June 8, 2020, 5:46am UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/4 "2020-06-08T05:46:15Z")

</div>

it works - thanks.  
But i habe to trigger it again for actual date/time.  
I hope for a function to format the App Info.Current Date and Time-Variable in the head of the apps without the time zone information

Regards Christian

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [June 8, 2020, 2:43pm UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/5 "2020-06-08T14:43:55Z")

</div>

OK, good to hear @ChrisF.

You can also only display the Current Date (without timezone) as a variable if you’d like to include that in the header of the apps:

 ![Screen Shot 2020-06-08 at 10.38.36 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/42772827c0fb043cef3675d69b328e447365984f.png)

This is what it will look like when running the App:

 ![Screen Shot 2020-06-08 at 10.42.20 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/c43e89e564b8e736d36e9e677e2325f59650272f.jpeg)

Is this how you’d like to display the Date?

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [June 15, 2020, 8:23am UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/6 "2020-06-15T08:23:51Z")

</div>

Sorry, no.  
I like to see the current time (and date) without timezone. I don’t understand why tulip provide the user with this informationen

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [June 15, 2020, 12:46pm UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/7 "2020-06-15T12:46:03Z")

</div>

Good morning Chris,

I understand why it would be useful to display this information to a user. A good solution could be to use the FORMAT\_DATE\_TZ() function on a timer (every minute, for example) and display the variable as the current date and time. See below for an example:

 ![Screen Shot 2020-06-15 at 8.37.02 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/77d86752024325963b18bfbebe521ca5a17a87ea.jpeg) ![Screen Shot 2020-06-15 at 8.43.10 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/ce6d21078b0af2865ac63a4d19833fdc91a12267.jpeg)

Is this the information you’d like to display?

---

<div class="post-metadata">

**Author:** ![PascalW](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@PascalW](https://community.tulip.co/u/PascalW)\
**Post date:** [November 23, 2020, 7:54am UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/8 "2020-11-23T07:54:32Z")

</div>

Hello,

I have found this thread while looking for a way to format a DateTime variable within an App.  
For some reason the expression editor does not display the "FORMAT\_DATE\_TZ as an available function. However it still works if you simply type it out and configure it properly. (See screenshot below. The Test Variable is simply App Info.Current Date and Time)

 ![chrome_suVcnKAWYl](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/1d14e13eb71fc5c1400998f45f0a4e66533588cb.png)

I just wanted to make this post in case someone else finds this post and gets as confused as me.  
Are there any other potential functions that are simply not displayed as available but actually work? What can be done to enable the full list of all functions?

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 23, 2020, 9:17am UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/9 "2020-11-23T09:17:20Z")

</div>

hello @PascalW, welcome to the Tulip Community!!

this feature currently needs to be enabled for it to appear in your instance. if you could share your Tulip instance URL (via direct message to me), I will get it enabled for you.

---

<div class="post-metadata">

**Author:** ![PascalW](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@PascalW](https://community.tulip.co/u/PascalW)\
**Post date:** [November 23, 2020, 9:34am UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/10 "2020-11-23T09:34:35Z")

</div>

I can’t seem to find the option for sending DM (Neither on your profile nor on mine)  
The URL is: [https://dmgmori-academy-production.dmgmori-tulip.com/](https://dmgmori-academy-production.dmgmori-tulip.com/)

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 23, 2020, 12:04pm UTC](https://community.tulip.co/t/how-to-use-parse-datetime-tz/447/11 "2020-11-23T12:04:44Z")

</div>

hello @PascalW, I have enabled the feature for the instance you mentioned.

let us know if you any questions as you get started using it!!
