Does the Time zone of the date column changes when we connect data from salesforce connector?

Nandha_Kumar_1

When i directly extract data from salesforce the date shows 1st October 2023.
When i connect through salesforce connector in domo the date from domo sales force connector shows 30th September 2023.

So does the salesforce connector in domo changes the timezone of the date when compared to actual salesforce date?

ColemenWilson

Hello, this knowledge article walks through instance time zone setting and how they affect dates: https://domo-support.domo.com/s/article/360042934394?language=en_US

jessdoe

To reconcile your timezone in Domo with that of Salesforce or any other platform whenever there's a difference, the convert_tz function is best and works in magic etl, sql dataflows, and beastmode:

convert_tz(`time_column`,'FROM_timezone', 'TO_timezone'

e.g.: convert_tz(`mydatetimecolumn`, 'PST', 'US/Central')

ColemenWilson

Hello, this knowledge article walks through instance time zone setting and how they affect dates: https://domo-support.domo.com/s/article/360042934394?language=en_US

jessdoe

To reconcile your timezone in Domo with that of Salesforce or any other platform whenever there's a difference, the convert_tz function is best and works in magic etl, sql dataflows, and beastmode:

convert_tz(`time_column`,'FROM_timezone', 'TO_timezone'

e.g.: convert_tz(`mydatetimecolumn`, 'PST', 'US/Central')