Hi Everyone,
I have a sub zap in which it is accessed with the desired date format (London) from the main Zap. I can see that the ‘DATA IN’ is in the right format. But the ‘Data Out’ in both ‘updating CRM step’ & ‘Zapier table step’ is coming out as american date format. Is it something I am doing wrong or technical issues that needs back end sorting.
Attached is the screenshot.
Thanks
Sooraj
Best answer by Troy TessaloneBest answer by Troy Tessalone
The Freshsuite Sales field “Date Booked UDR Course” is a DateTime field type.
Most apps store dates in ISO format which is a standard.
You don’t have control for how Freshsuite Sales returns the field format.
You do have control for how you send data into Freshsuite Sales for a field.
Freshsuite Sales likely expects a standardized date format, otherwise it can misinterpret the provided value.
e.g. YYYY-MM-DD
You can use a Formatter > Date & Time > Format step to adjust a timestamp value.
+14Hi
For us to have more context, post screenshots with how the Zap step is configured in EDIT mode so we can see the field types and field descriptions.
Hi Troy, Thank you for the response.
Please see screenshot -1: Date added to the CRM field
Screenshot 2: Date accessed is from the 1st step in this subzap.
Screenshot 3: Main zap pulling the date for the subzap.
Hope this helps.
+14The Freshsuite Sales field “Date Booked UDR Course” is a DateTime field type.
Most apps store dates in ISO format which is a standard.
You don’t have control for how Freshsuite Sales returns the field format.
You do have control for how you send data into Freshsuite Sales for a field.
Freshsuite Sales likely expects a standardized date format, otherwise it can misinterpret the provided value.
e.g. YYYY-MM-DD
You can use a Formatter > Date & Time > Format step to adjust a timestamp value.
Hi Troy,
Thank you for the quick response.
So in this case, as the data going in is in the right format, is it the fresh sales that requires correction?
OR
The date format that is going in should be e.g. YYYY-MM-DD for Fresh sales to interpret it correctly, instead of DD-MM-YY?
Could you please point out where exactly needs the correction.
Note: The date has been formatted already from the previous steps in the Main Zap to DD-YY-MM format.
+14When in doubt, use ISO formatting for timestamps.
Date: YYYY-MM-DD
DateTime: YYYY-MM-DDTHH:mm:ssZ
These are available formats to select in the Formatter > Date & Time > Format options.
ISO: https://en.wikipedia.org/wiki/ISO_8601
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
