Kate
See below for details:
Email Template:
You have been scheduled for and event on : {!Event.ActivityDate}
Subject: {!Event.Subject}
Start Date/Time: {!Event.StartDateTime}
End Date/Time: {!Event.EndDateTime}
Location: {!Event.Location}
Event Duration: {!Event.DurationInMinutes}
Description: {!Event.Description}
For more details on this event please click: {!Event.Link}
Resulting Email:
To: Kate Walsh;
You have been scheduled for and event on : 7/7/2016
Subject: WO-00041253
Start Date/Time: 7/7/2016
End Date/Time: 7/7/2016
Location: Kate Walsh Field Acct
Event Duration: 240
Description: Testing Email Template
For more details on this event please click: https://na12.salesforce.com/00UU0000018LhIB
11 answers
I tried both the options but its not working for me. Can anyone help me on this? Hello Kate,
So this is a know issue so vote it up here.
https://success.salesforce.com/ideaView?id=08730000000BqD2
http://help.salesforce.com/HTViewSolution?id=000006726
You could create a formula field to get the time and then put that on your email template.
https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm check out the Finding the Hour, Minute, or Second from a Date/Time section.Oldy but goody . . it worked to solve my issue 8 23 2023 :) Thank you!
To display only the time, use:
{!LEFT(TEXT(TIMEVALUE(Event.StartDateTime)),5)}
This converts the TimeValue (“HH:MM:
SS.MS”) to text then uses just the leftmost 5 characters.@Jim Kacerguis
Yes "DATETIMEVALUE" will always work.This method provided by salesforce itself@Ajay,
That seems to work, but I don't understand why? Is StartDateTime a date/time field? Also, will this always work (i.e. it will still display the correct time for DST changes?)
