Right now I have a picklist field the I want to be used in an Email Template.
The picklist values are "Monday, January 17th 5:30 PM" and "Saturday, March 18th 10:00 AM".
The formula I have of now is {!MID(Contact.Date__c,1,LEN(Contact.Date__c) - 9)}
which takes 9 characters from the right side and cuts it off which works for the Saturday, March 18th 10:00 AM but not for the other date.
How do I create a formula that is dynamic so the merge field works for both pick list values?
EX. If the user selects Monday, January 17th 5:30 PM it should return Monday, January 17th and if the user selects Saturday, March 18th 10:00 AM it should return March 18th 10:00AM.
Datetime
type fields to store the value? Then you could doDATEVALUE(Datetime_Field__c)
.