Another date time parse issue

Need to parse datetime in this format from a string “5 Mar 2024 5:01 PM” so I can set google calendar events. The value comes from a webhook and the field name is Appointment_Date_Time.

Variable Value Used: (See screenshot)
{{parseDate(1.Appointment_Date_Time; " D MMM YYYY h:mm A")}}

Error

DataError

Failed to map ‘value’: Function ‘parseDate’ finished with error! ‘15 Mar 2024 5:00 PM’ is not a valid date or does not match the date format.

Origin

Make

Automatic error handler

If you want to handle this error automatically, choose one of the following options. This will create a new error-handler route in your scenario. You can then expand the route in any way you like.

Ignore all errors
Ignore errors of type DataError

Output from Webhook:
[
{
“Address”: “712 Rossmore Ave, Pittsburgh, PA 15226, USA”,
“Link_to_Podio”: “Login | Podio”,
“Name”: “Gabriel Guerra”,
“Phone”: “work:+14129323555,work:+14126669999”,
“Email”: “faizul@360homeoffers.com”,
“Zillow”: “http://www.zillow.com/homes/712-Rossmore-Ave,-Pittsburgh,-PA-15226,-USA_rb”,
“ARV”: “”,
“As_is”: “”,
“Type”: “Single Family”,
“Bedrooms”: “3”,
“Bathrooms”: “2”,
“Sqft”: “1990”,
“Contract_Price”: “150,000.00”,
“Contract_Type”: “Cash”,
“Exit_Strategy”: “Assignment”,
“EMD”: “100.00”,
“Contract_Signed_Date”: “25 Apr 2024”,
“Due_Diligence_Date”: “27 Apr 2024”,
“Closing_Date”: “30 Apr 2024”,
“Additional_Terms”: “\nDude is super cool. \n”,
“Acquisition_Notes”: “\nThis man wanst to sell. Hella thirsty\n”,
“Notes_to_TC_Dispo_from_ACQ”: “\nwow. more sellers should be like this\n”,
“Appointment_Date_Time”: “15 Mar 2024 5:00 PM”,
IMTMETHOD”: “POST”
}
]

image

I think the issue has been solved. I had an extra space

2 Likes

Hello there @faizi :wave:

Great to hear that you’re not expeiriencing this issue anymore. Also thanks a lot for keeping us updated.

Keep up the great job! :muscle:

1 Like