Date Time Values and Integrations

Administrators can include Date/Time values within their integration setting. Date/Time values must be passed to third-party APIs in the proper format to ensure the integration works as expected.

Inbound Integrations

The Date/Time format must be YYYY-MM-DD hh:mm:ss. Keep in mind the format does not include a time zone. 

If the integration is public, the time zone assigned to the Community Hub Guest user profile is used. Learn more about Community Hub Users, Accounts, Permission Sets, and Profiles.

If the integration is private, the time zone of the authenticated user is used.

Time should always be recorded as military time from 00:00:00 - 23:59:59.

Outbound Integrations

The date/time format must be YYYY-MM-DDThh:mm:ssZ. Outbound integrations require a time zone value. When you want to query Nimble AMS based on a Date/Time field, the Date/Time must include a time zone value. The T in the date format represents the GMT/UTC time zone. Any adjustment to the time zone is represented in the date format by Z and should include + or - followed by the time adjustment for that time zone.

ExampleTo query based on EST time, then the Date/Time value should be: YYYY-MM-DDThh:mm:ss-05:00

Time should always be recorded as military time from 00:00:00 - 23:59:59. To learn more about time zones see Date Formats and Date Literals (external).