Hey @SanfordWhiteman , I am able to fetch the correct meeting value as per the days difference from the multiple Meeting date but I want to change the format of it like Friday, Mar. 05 at 12:00 AM
Appointment_Start_DateTime_Text__c is the text data type attribute. The value store in this like : 03/05/2021 10:37:00 AM CST
I don't want to use any static Time zone to convert it because each records have different TimeZone value.
So just want to convert the format of date and display in the Email content. Also I want to remove the ss (Seconds) part from the Time.
#set($x = $date.calendar)
#foreach( $Meeting in $Activity_Marketo__cList)
#set ( $Appointment_Start = $date.toDate("MM/dd/yyyy hh:mm:ss a", $Meeting.Appointment_Start_DateTime_Text__c) )
#set($is_upcoming = $date.difference($x.time,$Appointment_Start).days)
#if($is_upcoming == 😎 <br>
$Appointment_Start<br>
#end
#end
Using this above script, the Output I received is "Fri Mar 05 10:37:00 CST 2021" but I want it like "Friday, Mar. 05 at 12:00 AM"
Can you please suggest what I need to update in the above script.
... View more