Application ID
B0465737-40EA-04F3-FF0C-9CF262E5C500
I’m trying to use the Zapier integration to create a new object in a data table, but keep running into the error “Invalid date format for property birthday.” The ‘birthday’ property is set as type DateTime in the Backendless schema.
When setting up the action in Zapier, Zapier appears to recognize the ‘birthday’ property as DateTime, and seems to automatically format the data to be sent to Backendless.
Setting up the action in Zapier (note the DateTime icon next to the field name, indicating that Zapier automatically formats the data):
The data formatted by Zapier and sent to Backendless: 
The error screen:
If I had to guess, this seems to be an incompatibility between the formatting Zapier sets and the formatting Backendless allows for DateTime values?.. But it’s very likely that I’m overlooking something. Please let me know if I can provide any other information to help solve this issue.
Thank you!
Hello @Lighthouse_Global,
Backendless recognizes the following formats for the date-time column:
EEE MMM dd HH:mm:ss zzz yyyy;
yyyy-MM-dd'T'HH:mm:ss.SSS'Z';
MM/dd/yyyy HH:mm:ss 'GMT'z;
MM.dd.yyyy HH:mm:ss 'GMT'z;
MM-dd-yyyy HH:mm:ss 'GMT'z;
MM/dd/yyyy HH:mm:ss z;
MM.dd.yyyy HH:mm:ss z;
MM.dd.yyyy HH:mm:ss;
MM-dd-yyyy HH:mm:ss;
MM/dd/yyyy HH:mm:ss;
MM.dd.yyyy;
MM-dd-yyyy;
MM/dd/yyyy;
MM/dd/yyyy HH:mm:ss 'GMT'Z;
MM/dd/yyyy HH:mm;
dd/MMM/yyyy;
dd-MMM-yyyy;
EEEEE, d MMMMM yyyy;
yyyy/MM/d/HH:mm:ss;
yyyy-MM-dd'T'HH:mm:ss;
EEEEE, MMMMM d, yyyy;
MMMMM d, yyyy;yyyy M d;
yyyyMMMd;
yyyy-MMM-d;
yyyy-M-d, E;
'Date' yyyy-MM-dd;
yyyy-MM-dd'T'HH:mm:ss;
yyyy-MM-dd'T'HH:mmZ;
yyyy-MM-dd;
yyyy-'W'w;
yyyy-DDD;
d MMMMM yyyy, HH'h' mm'm' ss's';
yyyy-MM-dd HH:mm:ss.SSS
It is compatible with the DateTimeFormatter (Java Platform SE 8 )
You can use Zapier’s formatter or some service in order to change the payload that will be sent to Backendless.
Regards,
Stanislaw
Here is a great Zapier article that describes how to format dates:
