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