# Datetime value formatting

**URL:** <https://community.tulip.co/t/datetime-value-formatting/12594>\
**Category:** Product Suggestions\
**Created:** [September 30, 2024, 2:57am UTC](https://community.tulip.co/t/datetime-value-formatting/12594 "2024-09-30T02:57:19Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![kkl](https://avatars.discourse-cdn.com/v4/letter/k/9d8465/32.png) [@kkl](https://community.tulip.co/u/kkl)\
**Post date:** [September 30, 2024, 2:57am UTC](https://community.tulip.co/t/datetime-value-formatting/12594/1 "2024-09-30T02:57:19Z")

</div>

Hello,

Is it possible to include options for datetime value formatting (table / variables)? Datetime formats are cumbersome and difficult to read in some cases. Often users don’t want to see the timezone or the hours/minutes of the selected date and are only interested in seeing the day, month, year. Can this configurability be added on the app editor level (similar to the recent updates created for numbers/decimals)?

---

<div class="post-metadata">

**Author:** ![shep](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/shep/32/8231_2.png) [@shep](https://community.tulip.co/u/shep)\
**Post date:** [September 30, 2024, 6:40pm UTC](https://community.tulip.co/t/datetime-value-formatting/12594/2 "2024-09-30T18:40:10Z")

</div>

Hi @kkl thanks for the suggestion. We are currently looking into giving more customization for our variable value formatting in Apps, Datetime included.

As a workaround for now, you can resize the Datetime variable to only display the date in the App Editor. This would make it so the operator doesn’t see the time and timezone if that’s not necessary.

Hope this helps for now until we improve it!

---

<div class="post-metadata">

**Author:** ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)\
**Post date:** [October 2, 2024, 8:04am UTC](https://community.tulip.co/t/datetime-value-formatting/12594/3 "2024-10-02T08:04:59Z")

</div>

> [@shep](#):
>
> As a workaround for now, you can resize the Datetime variable to only display the date in the App Editor.

Do you mean the column width with that suggestion?

---

<div class="post-metadata">

**Author:** ![Alinator](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@Alinator](https://community.tulip.co/u/Alinator)\
**Post date:** [October 2, 2024, 12:52pm UTC](https://community.tulip.co/t/datetime-value-formatting/12594/4 "2024-10-02T12:52:53Z")

</div>

Hey @kkl, another workaround we have used with some success is to add a trigger to store the datetime variable into a text variable using an expression and the DATETIMETOTEXT() function.

[DATETIMETOTEXT() details on the Knowledgebase](https://support.tulip.co/docs/using-datetime-expressions#typecasting-datetime)

And links to relevant formatting codes because it appears the relevant links have been removed from the Knowledgebase (as of 2 Oct 2024):

> **[Moment.js cheatsheet](https://devhints.io/moment)**
>
> The one-page guide to Moment.js: usage, examples, links, snippets, and more.

And the timezone link from the Knowledgebase article for convenience:

> **[PHP: List of Supported Timezones - Manual](https://www.php.net/manual/en/timezones.php)**
>
> PHP is a popular general-purpose scripting language that powers everything from your blog to the most popular websites in the world.

---

<div class="post-metadata">

**Author:** ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)\
**Post date:** [October 2, 2024, 1:03pm UTC](https://community.tulip.co/t/datetime-value-formatting/12594/5 "2024-10-02T13:03:33Z")

</div>

> [@Alinator](#):
>
> to add a trigger to store the datetime variable into a text variable using an expression and the DATETIMETOTEXT() function

Unfortunately that works only on single values and not on Interactive Table columns or so…

---

<div class="post-metadata">

**Author:** ![shep](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/shep/32/8231_2.png) [@shep](https://community.tulip.co/u/shep)\
**Post date:** [October 2, 2024, 7:42pm UTC](https://community.tulip.co/t/datetime-value-formatting/12594/6 "2024-10-02T19:42:44Z")

</div>

I suppose my suggestion does not work well for showing datetime in a table, only for a variable value (text).

---

<div class="post-metadata">

**Author:** ![kkl](https://avatars.discourse-cdn.com/v4/letter/k/9d8465/32.png) [@kkl](https://community.tulip.co/u/kkl)\
**Post date:** [October 3, 2024, 2:36am UTC](https://community.tulip.co/t/datetime-value-formatting/12594/7 "2024-10-03T02:36:49Z")

</div>

Hi @shep @Alinator thanks for the suggestions. My coworkers and I have definitely performed those work arounds and are aware of them. Really hoping to not have this workaround and have a direct route to formatting the datetimes as desired.

Best,  
Kevin

---

<div class="post-metadata">

**Author:** ![shep](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/shep/32/8231_2.png) [@shep](https://community.tulip.co/u/shep)\
**Post date:** [October 3, 2024, 6:13pm UTC](https://community.tulip.co/t/datetime-value-formatting/12594/8 "2024-10-03T18:13:28Z")

</div>

@kkl understood. We will see what we can do!

---

<div class="post-metadata">

**Author:** ![ta-aoki](https://avatars.discourse-cdn.com/v4/letter/t/a587f6/32.png) [@ta-aoki](https://community.tulip.co/u/ta-aoki)\
**Post date:** [October 31, 2025, 6:55am UTC](https://community.tulip.co/t/datetime-value-formatting/12594/9 "2025-10-31T06:55:42Z")

</div>

Any updates?

I want this feature of letting App developers to specify the datetime format for each column of the interactive table.

We have some users using Tulip Player on their smartphones.  
For some interactive table, what they only need to see in their daily use case is just “month” and “day” of the date. We do not want to take valuable space of smartphone screen with the “year” and the “time”.  
However, we do need to have the “year” inside the record, for other use cases.

We do not want to use multiple fields (year/month+day) since it may easily lead to inconsistency if we do not carefully implement the triggers.

---

<div class="post-metadata">

**Author:** ![OlgaStroilova](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/olgastroilova/32/7199_2.png) [@OlgaStroilova](https://community.tulip.co/u/OlgaStroilova)\
**Post date:** [November 1, 2025, 3:09pm UTC](https://community.tulip.co/t/datetime-value-formatting/12594/10 "2025-11-01T15:09:13Z")

</div>

Thank you @ta-aoki for upvoting this suggestion.

Better native DateTime formatting including for columns on interactive tables and on specific display devices is on our radar, but isn’t yet on our near-term roadmap. We’re keeping an eye on Community upvotes.

Flagging this also to your CSM for Customer prioritization @DanielT

---

<div class="post-metadata">

**Author:** ![kellen.linse](https://avatars.discourse-cdn.com/v4/letter/k/e99b99/32.png) [@kellen.linse](https://community.tulip.co/u/kellen.linse)\
**Post date:** [January 29, 2026, 12:03am UTC](https://community.tulip.co/t/datetime-value-formatting/12594/11 "2026-01-29T00:03:00Z")

</div>

Just going to put a +1 on this so it stays on the radar.
