Facebook Lead Forms Sending DOB as March 3, 1958 or April 17, 1966 - How to convert this back to MM-DD-YYYY ?!?!

Facebook Lead Forms recently started sending DOB data over as March 3, 1953 instead of the usual 03-03-1953. FormatDate doesn’t seem to handle that well. What is the cleanest way to assign the appropriate month back to the corresponding month number?

I tried to use the parseDate function to then do a formatDate, but the Parse Date Function failed as well.

Attached a Photo where FormatDate is also throwing an error

Hi there.

Check the attached testing scenario blueprint that shows how to work with parsing and then formatting the date.

Also, check the following links that should help:


blueprint (5).json (4.2 KB)