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

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?
Best Answers
-
Hello, this knowledge article walks through instance time zone setting and how they affect dates:
If I solved your problem, please select "yes" above
0 -
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')
0
Answers
-
Hello, this knowledge article walks through instance time zone setting and how they affect dates:
If I solved your problem, please select "yes" above
0 -
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')
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive