I'm looking for a way to convert the CreatedDate and Call_Start_Time fields in Salesforce to a different TimeZone. Is there a way to change the data that is queried to display a different timezone.
Any assistance is appreciated.
Should really take this inquiry into the Toad Data Point forum, please.
Have you tried applying the Transform & cleanse engine in Toad Data Point to your Salesforce data?
e.g. right-click on the results set or data grid and choose Send To -> Transform & Cleanse...
There are some date-time functions that can produce what you need. You may need to convert your date-time stamp format into pure date format first before applying. See screen snapshot below.
Gary,
It got me further. Sorry I had mean to post into Toad Data Point. I will try there for further assistance.
Thank you for your quick response.