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

Nandha_Kumar_1
Nandha_Kumar_1 Member
in Connectors

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?

Tagged:

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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

    If I solved your problem, please select "yes" above

  • jessdoe
    jessdoe Contributor
    Answer ✓

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

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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

    If I solved your problem, please select "yes" above

  • jessdoe
    jessdoe Contributor
    Answer ✓

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

Categories