Question
When registering date and time data in the Salesforce connector, can I specify a time zone?
Answer
Yes, you can specify time zone information to register in Salesforce connector.
If time zone information is included in the registration data, Salesforce connector will register the data with the time zone information retained.
If the registration data does not contain time zone information, the Salesforce connector will register with the time zone information of HULFT Square.
Example 1
If data does not have time zone information and the time zone setting of HULFT Square is Asia/Tokyo, the data "2016-01-01 00:00:00" will be registered as "2016-01-01T00:00:00.000+0900".
If you want to register data in appropriate time zone, use the Date/Time Formatting logic to convert the date/time data into a string, add the time zone information to the string, and then use the Parse Date/Time logic to convert the string into date/time data before registering it.
Example 2
If you want to register the date and time information "2016-01-01 00:00:00" in the Japanese time zone, convert it to a string data "2016-01-01T00:00:00.000+0900" in Data/Time Formatting logic, and then convert it to "yyyy -MM-dd'T'HH:mm:ss.SSSZZ" format in Parse Date/Time logic before registering it.
Date/Time Formatting
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/Iso8601ToCustom.htm
Parse Date/Time
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/CustomToIso8601.htm
Comments
0 comments
Article is closed for comments.