Different Responses for Test request vs production request on Date/Time data

[Prasann]

Hi,
I have created a workflow which takes date data in (YYYY-MM-DD HH:mm:ss Z) format and sends an appointment date to clients in DD-MM-YYYY format and time in HH:mm:ss A format. While testing the request I'm getting proper data but when I'm adding th exact same data in google sheets, I'm getting appointment date as "Invalid" and appointment time as "date". Can someone please help?
Attaching both the responses as screenshot for reference

 

[ArshilAhmad]

Hi @Prasann,

Based on your Task History, it seems like you made changes to the Date column header in your Google Sheets spreadsheet after setting up your workflow. As a result, the date is not being mapped in the next steps, leading to the encountered error. During the initial workflow setup, the header was 'Appointment Date (DD-MM-YYYY)', and it has now been changed to 'Appointment Date (YYYY-MM-DD)'.

To resolve this issue, click on the 'Re-Capture Webhook Response' button and capture a new response in your workflow setup. This will provide you with the updated column header, which you need to map in the next steps.