# Formatting UTC Date

**URL:** <https://community.fibery.io/t/formatting-utc-date/5492>\
**Category:** Get Help\
**Tags:** formulas, dates\
**Created:** [December 4, 2023, 12:43pm UTC](https://community.fibery.io/t/formatting-utc-date/5492 "2023-12-04T12:43:38Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [December 4, 2023, 1:22pm UTC](https://community.fibery.io/t/formatting-utc-date/5492/4 "2023-12-04T13:22:29Z")

</div>

Is this any use?

> [@Timezone offset calculation](https://community.fibery.io/t/timezone-offset-calculation/3239/6):
>
> I have dug into timezones a little, and concluded that it is possible to write a formula that will convert a DateTime value to a Date field based on a specific timezone, taking into account daylight saving. In the case of Europe, the formula would be as follows: DateTimeField + Hours( If( DateTimeField \> Date(Year(DateTimeField), 4, 1) - Days( If( WeekDayName(Date(Year(DateTimeField), 4, 1)) = "Monday", 1, If( …

Note: If a date field is typecast to a datetime field, it takes the time as midnight (UTC).

---

_[View the full topic](https://community.fibery.io/t/formatting-utc-date/5492)._