Hi All,
I'm building an integration with NetSuite and I need to send the Order Product information "Start and EndDate" both are defined as "Date" into Saleforce, but when I try to set on field set as "Date" into NetSuite it's requested a format of DateTime.
Is there any workaround to convert in a Custom Expression a Date field into a Datetime?
Hi @Fabio Maturo - Great question!
We will be launching typecasting formulas in the Custom Expression Editor (like fromDateToDateTime) by the end of the month.
If you need a workaround in the meantime, you can create a new formula field in Salesforce of type DateTime = DATETIMEVALUE(Date field:Start Date). This converts the Date to a DateTime and then the Composer can use that field to map to NetSuite.
Keep in mind, however, that for the Salesforce formula, the time will be set to 12:00 a.m. in Greenwich Mean Time (GMT), and then converted to the time zone of the user viewing the record when it’s displayed. We recommend that the integration user should have its time zone set to UTC in both Salesforce and NetSuite.
Hope this helps!
Hi @Volodymyr Panasenko - A typecasting formula is not needed in this case as Composer automatically handles the translation between DateTimes and Dates. You can map a DateTime data pill into a Date field and Composer will automatically typecast it for you.
