How to import date time values for the user properties?

Import from CSV

• Mailmodo recognizes and stores values in YYYY-MM-DD format for the DateTime properties uploaded via CSV. Values in any other format will not be stored

Please refer to this article for formatting your date values into the YYYY-MM-DD format using MS Excel or Google Sheets

Add through addToList API

• Properties with the values in ISO format at the time of the first encounter by Mailmodo will be assigned date data type. Post that, the values can be sent in both ISO as well as Unix (in seconds)
• Values not in ISO/Unix will be sent an error response with the message "The <property_name> property accept(s) values in UNIX/ISO format"

Import from Apps

HubSpot, Mixpanel, and Salesforce

Default properties

• Please refer to this article for the date properties getting imported from the default properties in HubSpot
• Please refer to this article for the date properties getting imported from the reserved properties in Mixpanel

Non-default properties

• Properties with values in ISO at the time of the first encounter by Mailmodo will be assigned date data type. Post that, the values can be sent in both ISO as well as Unix (in seconds)
• While syncing, values adhering to ISO/Unix will be stored and the rest will be ignored

Segment.io

Default traits

• Please refer to this article for the date properties getting imported from the default properties in HubSpot

Custom traits

• Properties with values in ISO at the time of the first encounter by Mailmodo will be assigned date data type. Post that, the values can be sent in both ISO as well as Unix (in seconds)
• Values not adhering will be sent an error response with the message "The <property_name> property accept(s) values in UNIX/ISO format"