Good day StackExchange!
High level, my goal is to take a date/time value and use a formula to display it as a customer friendly long date (MMMM-DD,YYYY at HH:MM AM/PM) string output for email templates.
My issue is each formula output only gives me half of what I'd like.
A Date/Time formula output gives me "1/29/2020 1:00 PM"
A Text formula output using CASE,DAY,YEAR and TIMEVALUE gives me "January 29 2020 13:00:00.000"
Is it possible to get an output of "January 29 2020 1:00 PM" using only one formula field, and without creating additional fields as value holders?
Apex is a last option as that has a budget cost.
Any help graciously appreciated. My current formula below:
CASE(
(MONTH(DATEVALUE(Next_Meeting__c))),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
"December"
) & " " &
TEXT((DAY(DATEVALUE(Next_Meeting__c)))) & " " &
TEXT((YEAR(DATEVALUE(Next_Meeting__c)))) & " " &
TEXT(TIMEVALUE(Next_Meeting__c - (( $User.UserTimezoneOffset__c + Lead1__r.TZ_Offset__c) * 60)/1440))