The date coming in via our web to lead in is not picked up by the date field in Salesforce, I changed the field to text and it comes through as YYYY-MM-DD. I want to create a formula to autopopulate this as a date in another field but keep getting an error message. Help please!