Formatting UTC Date

[Chr1sG]

Is this any use?

Timezone offset calculation

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).