Hey,   I want to display Meeting StartTime and End time (Total Meeting time is 30 minutes) like Tuesday, May 18, 10:00 -- 10:30 am EDT The field I am using is 'Appointment_Start_DateTime_Text__c' (DataType = Text).   The value of the 'Appointment_Start_DateTime_Text__c' is '05/03/2021 10:00:00 AM EDT' #foreach($obj in $sorter.sort($Activity_Marketo__cList , "CreatedDate__c:desc")) #set($Appointment_Start = $date.toDate("MM/dd/yyyy hh:mm:ss a", $obj.Appointment_Start_DateTime_Text__c)) #set($dateFormatted = $date.format("EEEE, MMM. dd", $Appointment_Start)) #set($salutationdate = $date.format("MMMM d", $Appointment_Start)) #set($dateFormattedHours = $date.format("hh:mm a", $Appointment_Start)) #set($FormattedStartDate = $date.format("EEEEE, MMMM d,", $Appointment_Start)) #set($FormattedStartTime = $date.format("h:mm", $Appointment_Start)) ## EndTime ## #set($FormattedEndTime1 = $Appointment_Start.calendar) #set($FormattedEndTime = $FormattedEndTime1.add(12,30)) ## EndTime ## #set($AMPM = $date.format("a", $Appointment_Start)) ## TimeZone ## #set ($Appointment = "$obj.Appointment_Start_DateTime_Text__c") #set ($stringLength = $obj.Appointment_Start_DateTime_Text__c.length() - 0) #set ($AppointmentTimeZone = $Appointment.substring(23,$stringLength)) ## TimZone ## $FormattedStartDate $FormattedStartTime -- $FormattedEndTime $AMPM.toLowerCase() $AppointmentTimeZone #break #end The Output is --> Monday, May 3, 10:00 -- $FormattedEndTime am EDT   Can any one help me ASAP what is wrong in the EndTime script. Thanks in advanced! ... View more

The StartDateTime value is like 2021-04-06 17:00:00 in Marketo. I want to fetch the records for 6th Day. Does is calculate with date and Time both or only for Date difference for any of the future records How does condition work For DateTime data type custom field in the Smart list? And if I want to add the same condition in the Velocity Script of the Mytoken to fetch the Meeting date in the email content, How can I write the script? ... View more

Hello, We have a Mytoken added in the email content which pulls the Meeting details(Date and Time) of an appointment. We have faced scenarios where the sometimes Mytoken doesn't pull any value and sends out the email blank(with empty space of Mytoken value).   Is there any way we can stop the email when Mytoken used in that email doesn't have a value?   So If Mytoken has value ---> Need to send the email If empty value ---> No need to send the email to that record. Can anyone please help ASAP. ... View more

    #set($x = $date.calendar) ##$Activity_Marketo__cList.size() ##$Activity_Marketo__cList #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) #set($formattedDate = $date.toDate("hh:mm:ss", $x.time)) #set($splitData = $Meeting.Appointment_Start_DateTime_Text__c.split(" ")) #set($leadHeader = $display.list($Meeting.Appointment_Start_DateTime_Text__c.split(" "),"<br>")) #if($is_upcoming == 1 && !$Meeting.StartDateTime__c.isEmpty() && $Meeting.Meeting_Sub_Type__c == "Initial" && $display.alt($Meeting.Meeting_Status__c,"").isEmpty() && !$Meeting.Meeting_Origin__c.isEmpty() && $Meeting.Event_Type__c == "Prospect Meeting" && $Meeting.IsChild__c == 0) $splitData[0] <br> #set($time = $splitData[1].split(":")) $time[0]:$time[1] $splitData[2] $splitData[3] ##$Meeting <br> ##$Meeting.Name ##$Appointment_Start<br /> ##Meeting SubType: $Meeting.Meeting_Sub_Type__c ##Differences: $is_upcoming <br /> #end #end     The records are qualified in the Smart campaigns.   We need to fetch the Meeting date after 2 days if all the condition added in the IF conditions satisfied. If we check in the Email preview it shows the correct Date (03/11/2021 01:00 AM PST) but When we run the campaign it shows nothing- Empty space 😞   Records have all the details correct added in the IF condition.   Can somebody please help with this ASAP. ... View more

Hello, #if( !$display.alt($Activity_Marketo__cList.get(0).Appointment_Start_DateTime_Text__c,"").isEmpty() ) #set ( $Appointment_Start = $date.toDate("MM/dd/yyyy hh:mm:ss a", $Activity_Marketo__cList.get(0).Appointment_Start_DateTime_Text__c) ) ${date.format("MM/dd/yyyy", $Appointment_Start)} #end   We are adding above velocity script code to retrieve meeting details in the email content. But the emails are fetching the first available meeting date and not fetching the correct meeting date as per the campaign conditions as one record has multiple meetings. How can I displayed the date as per the Smart campaign's date conditions such as StartDateTime (data type=datetime) in future after 7 days. The field I am using in the velocity script is Appointment_Start_DateTime_Text__c(Data Type=Text). Appointment_Start_DateTime_Text__c and StartDateTime both have the same value just the data type is different. ... View more

We created a task in Marketo to write back to Salesforce where a planner/owner is assigned a task but the field "Related to" as you can see in the screenshot below is empty.     Here we want the user to flow in the "Related to" field so that the planner gets to know which user/lead is to be served. Is there any way we can have 'related to' field populating with the corresponding user/lead through Marketo. ... View more