Raw Data Table dates time zone

#1

Hi all,

I need some guidance on displaying dates in my Raw Data Table (RDT) according to each user’s local timezone. Currently, all users see dates based on a single default/server timezone. For instance, a UTC timestamp should appear differently for a user in New York (EDT) versus one in Berlin (CEST).

What is the best way to do this? I’m wondering about reliable ways to detect a user’s timezone and whether it’s better to handle the conversion server-side or client-side with JavaScript.

Thanks for any help!

#2

Actually you can do it by adding a configuration to your metadata, like this:

let customMeta = {
    'your_source_name': {
        'fields': {
            'your_date_field': { 
                'tz':  'your_time_zone', // eg: 'Europe/Amsterdam'
                }
        }
    }
}

You can check the available timezones here: Supported time zones

#3

It works good, but actually i want something for the whole data, not just a single field, can you help me with a more general configuration?

#4

I see, well the logic is similar but a the source level, let me show you:

let customMeta = {
    'your_source_name': {
        'tz':  'your_time_zone', // eg: 'Europe/Amsterdam'
    }
}
#5

It works good and was super easy, thanks for your help