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