You need to sign in to do that
Don't have an account?
How to get Salesforce Timezone from Jitterbit
Hi friends,
i'm posting this because Jitterbit does not have a lot of documentation about Salesforce. If you ever need to send information from Salesforce through an Outbound Message to Jitterbit and you have Date/Time Fields, you will need the timezone since Salesforce sends the UTC time. A work around that i found is this:
$SFFechaHoraActual=Date(LoginToSalesforceAndGetTimestamp("<TAG>Salesforce Orgs/admin@yourorg.com</TAG>"));
$SFFechaHoraActualCST=Date(FromDataLoaderDateTime($SFFechaHoraActual,"CST",true));
$TimeZoneDiff=Long($SFFechaHoraActualCST)- Long($SFFechaHoraActual);
Now you have the TimeZone in number and you could easy modify your date fields:
$SFFecha=if(IsNull($SFFecha) || $SFFecha=='', Now(), Date(Long($SFFecha)-Long($TimeZoneDiff)));
Cheers
Thanks for the info.
Regards,
Satish Kumar