# \#datetime

**URL:** https://community.tulip.co/tag/datetime/329.md

[Latest](https://community.tulip.co/latest.md) · [Categories](https://community.tulip.co/categories.md) · [Tags](https://community.tulip.co/tags.md)

---

## [Rounddatetime('week') ignores time zone and varies with user language settings](https://community.tulip.co/t/rounddatetime-week-ignores-time-zone-and-varies-with-user-language-settings/16352)

<div class="topic-metadata">

**Author:** [@JoakimBoda](https://community.tulip.co/u/JoakimBoda)\
**Replies:** 5\
**Last updated:** [May 28, 2026, 1:40pm UTC](https://community.tulip.co/t/rounddatetime-week-ignores-time-zone-and-varies-with-user-language-settings/16352 "2026-05-28T13:40:21Z")

</div>

I have encountered an issue with the rounddatetime() function when using the “week” unit in Tulip apps. The behavior changes depending on the user’s language settings, which leads to inconsistent results. To reproduce, …

---

## [Allow to use Datetime fields in Min and Max aggregations](https://community.tulip.co/t/allow-to-use-datetime-fields-in-min-and-max-aggregations/16147)

<div class="topic-metadata">

**Author:** [@fti](https://community.tulip.co/u/fti)\
**Replies:** 1\
**Last updated:** [March 5, 2026, 4:29pm UTC](https://community.tulip.co/t/allow-to-use-datetime-fields-in-min-and-max-aggregations/16147 "2026-03-05T16:29:15Z")

</div>

Greetings. I’ve noticed Datetime fields cannot be used when defining a Min or Max aggregation on a Tulip table. This sounds rather strange since these two aggregations make sense for a set of datetimes, Min being the “o…

---

## [Tulip SQL Connector using Datetime and DatetimeOffset](https://community.tulip.co/t/tulip-sql-connector-using-datetime-and-datetimeoffset/15681)

<div class="topic-metadata">

**Author:** [@Casey](https://community.tulip.co/u/Casey)\
**Replies:** 3\
**Last updated:** [October 3, 2025, 1:43pm UTC](https://community.tulip.co/t/tulip-sql-connector-using-datetime-and-datetimeoffset/15681 "2025-10-03T13:43:44Z")

</div>

Hello, I am currently using a SQL connector to log events that occur within an app as well as when a machine attribute changes to a SQL table and then query this data and show it to a user within the app via an interact…

---

## [Avoid getting Time Zone](https://community.tulip.co/t/avoid-getting-time-zone/14671)

<div class="topic-metadata">

**Author:** [@MarvinGarcia96](https://community.tulip.co/u/MarvinGarcia96)\
**Replies:** 4\
**Last updated:** [May 12, 2025, 12:49pm UTC](https://community.tulip.co/t/avoid-getting-time-zone/14671 "2025-05-12T12:49:59Z")

</div>

I’m currently taking Expressions course, which is out of date… and I was wondering how to avoid getting the time zone on the next trigger, as I see on the video’s app Tulip there no time zone but on my app im getting it,…

---

## [Best Practice for Custom GxP DateTime Format for Export & Excel Analysis](https://community.tulip.co/t/best-practice-for-custom-gxp-datetime-format-for-export-excel-analysis/12122)

<div class="topic-metadata">

**Author:** [@jmlowden](https://community.tulip.co/u/jmlowden)\
**Replies:** 1\
**Last updated:** [August 6, 2024, 12:38pm UTC](https://community.tulip.co/t/best-practice-for-custom-gxp-datetime-format-for-export-excel-analysis/12122 "2024-08-06T12:38:37Z")

</div>

I’m wondering if anyone can recommend a best practice for the Custom DateTime format for GxP use such that it still is month apparent but is also recognized as a proper datetime when the exported CSV is opened in Excel. …