American date format even after adding the right formatter step.
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
Page 1 / 1
Hi @Sooraj Rajaramadas
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.
@Sooraj Rajaramadas
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.
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.
@Sooraj Rajaramadas
When in doubt, use ISO formatting for timestamps.
Date: YYYY-MM-DD
DateTime: YYYY-MM-DDTHHssZ
These are available formats to select in the Formatter > Date & Time > Format options.