Handling multiple Timezone

AguWolkovicz — Wed, 10 Oct 2018 12:50:31 GMT

All,

I'm working on a scenario that requires dealing with different time zones, both in the ETL Process (Stages) and in a Mashup that final customers have access to.

ETL Process

In here, we aggregate data based on Dates that need to be converted to the Customer's local Timezone when accessing the Mashup.

Mashup

In here, we need certain dates to be displayed in the Customer's preferred Timezone (i.e.: the browser's Timezone).

For both cases, I haven't found any best practices, nor white papers, nor official suggestions/recommendations.

Has anyone struggled with such scenarios?

If so, are there any recommendations/suggestions based on experience about how to deal with this? Any direction is much appreciated.

Thanks in advance!

Agu.-

Re: Handling multiple Timezone

zsbaksa — Wed, 06 Mar 2024 06:51:26 GMT

Hey AguWolkovicz!

Did you find a solution for this?

Thanks

Re: Handling multiple Timezone

Dataintellinalytics — Fri, 15 Mar 2024 07:39:20 GMT

Did you try ConvertToLocalTime() function ?

topic Re: Handling multiple Timezone in App Development

Handling multiple Timezone

Re: Handling multiple Timezone

Re: Handling multiple Timezone