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

[Zach_Rucker]

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

[Milton_Bedford]

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:

• https://www.make.com/en/help/functions/date---time-functions
• https://www.make.com/en/help/functions/tokens-for-date-time-parsing
• https://www.make.com/en/help/functions/tokens-for-date-time-formatting

Cheers,

blueprint (5).json (4.2 KB)