1. Pendula for Enterprise
  2. Pendula user guides
  3. Integrations Hub
  4. Salesforce
  5. Pendula for Salesforce Integration

Reference
Working with Salesforce DATE and DATE/TIME fields

Malcolm Jacobson
Malcolm Jacobson
  • Updated

Pendula converts dates and times from external systems into a format that standardises data for internal processing.

When you use this data in external messages, you can use the Format date node to convert it into the appropriate format for the destination.

Working with Salesforce DATE fields

Salesforce DATE fields are stored in year, month, day (ISO 8601) format - YYYY-MM-DD.

If the date format for your message destination is reversed, you can use the Format date node to convert this to day, month, year, by selecting ISO8601 as the Input format, Custom Format as the Output format, and dd-MM-yyyy as the Token format.

This will return the date 2026-06-01 as the formatted date 01-06-2026.

Working with DATE/TIME fields

Salesforce DATE/TIME fields are converted to Pendula’s internal format on import. When referencing them in outbound messages, you must convert them to the format you want to use.

For example, to send the Scheduled Start time from a Service Appointment, add the Format date node to your flow and select Epoch/Unix as the Input format, and select your desired output from the Output format drop-down list.

For more formatting options, consult the documentation for the Format date node.