375
Hello D365 Community,
I cannot seem to find a "simple" way of extracting the TIME only from a DATETIME field in D365. Our specific scenario is that we need to provide the Start and End time values in an email template but the source is an OOB DATETIME field, which of course we need the Date for other requirements. Is there a tool or method in which to achieve this? I am open to any alternate recommendations as well.
Hi partner,
There are 2 ways for you.
1.Use js code to transfer the datetime from “yyyy-mm-dd hh:mm:ss” to "yyyy-mm-dd", You could add js code on the onload event of email.
Here are the sample code.
var startDate = Xrm.Page.getAttribute("yourattributename").getValue();
var hours = startDate.getHours();
var minutes = startDate.getMinutes();
alert(hours + ":" + minutes);
2.You could change the email template xml.
Hope it helps.
Best Regards,
Leo
Hi RugerSR762,
You can obtain the time with JavaScript.
Example JavaScript code:
function getTime()
{
var startDate = Xrm.Page.getAttribute("startdate").getValue();
var endDate = Xrm.Page.getAttribute("enddate").getValue();
var startHours = startDate.getHours();
var startMinutes = startDate.getMinutes();
var endHours = endDate.getHours();
var endMinutes = endDate.getMinutes();
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (