{"id":26141,"date":"2020-12-24T12:54:31","date_gmt":"2020-12-24T12:54:31","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=26141"},"modified":"2020-12-28T10:38:16","modified_gmt":"2020-12-28T10:38:16","slug":"convert-time-into-user-time-using-time-zone-codes","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/12\/convert-time-into-user-time-using-time-zone-codes\/","title":{"rendered":"Convert Time into User Time Using Time Zone Codes"},"content":{"rendered":"

Introduction<\/h1>\n

Recently we had one requirement in which we need to set the date field by user time zone. In this requirement using javascript, the manager creates (with the help of HTML web resource) multiple Appointment entity records dynamically for different users as owner and set date field (Start Time and End Time) as per owner time zone.
\nFirstly, we retrieve the time zone code information of the user. As per the fetchXml below, we read the time zone code information of the user by passing GUID of the user.<\/p>\n

\/\/Read the time zone codes of user
\nfunction setUserDateTimeZone(userId) {<\/p>\n

\/\/generate the fetchXml
\nvar fetchXml = “<fetch version=’1.0′ output-format=’xml-platform’ mapping=’logical’ distinct=’false’>”;
\nfetchXml += “<entity name=’usersettings’>”;
\nfetchXml += “<attribute name=’timezonecode’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightday’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightminute’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightyear’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightsecond’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightdayofweek’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylighthour’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightmonth’ \/>”;
\nfetchXml += “<attribute name=’timezonebias’ \/>”;
\nfetchXml += “<attribute name=’timezonedaylightbias’\/>”;
\nfetchXml += “<attribute name=’businessunitid’\/>”;
\nfetchXml += “<filter>”;
\nfetchXml += “<condition attribute=’systemuserid’ operator=’eq’ value='”+userId+”‘\/>”;
\nfetchXml += “<\/filter>”;
\nfetchXml += “<\/entity><\/fetch>”;<\/p>\n

\/\/get the result
\nfetchXml = “?fetchXml=” + encodeURIComponent(fetchXml);<\/p>\n

\/\/Fetch the user time zone information
\nXrm.WebApi.retrieveMultipleRecords(‘usersettings’, fetchXml).then(function success(results) {<\/p>\n

\/\/create time Zone object
\nvar timeZoneObj = {};
\ntimeZoneObj.timezonecode = results.entities[0][“timezonecode”];
\ntimeZoneObj.timezonebias = results.entities[0][“timezonebias”];
\ntimeZoneObj.timezonedaylightbias = results.entities[0][“timezonedaylightbias”];
\ntimeZoneObj.timezonedaylightday = results.entities[0][“timezonedaylightday”];
\ntimeZoneObj.timezonedaylightminute = results.entities[0][“timezonedaylightminute”];
\ntimeZoneObj.timezonedaylightyear = results.entities[0][“timezonedaylightyear”];
\ntimeZoneObj.timezonedaylightsecond = results.entities[0][“timezonedaylightsecond”];
\ntimeZoneObj.timezonedaylightdayofweek = results.entities[0][“timezonedaylightdayofweek”];
\ntimeZoneObj.timezonedaylighthour = results.entities[0][“timezonedaylighthour”];
\ntimeZoneObj.timezonedaylightmonth = results.entities[0][“timezonedaylightmonth”];
\n},
\nfunction (error) {
\nconsole.log(error.message);
\n});
\n}<\/p>\n

After getting the time zone Codes of the user, we convert the passed date time into the usertime. For this, we pass the date string with default (“+00:00”) offset value and time zone codes of the user to generateUserTime function below:<\/p>\n

var dateValue = “2020-12-25 12:30:30+00:00”;<\/p>\n

\/\/convert the given time to user Time Zone time
\nvar generateUserTime = function (dateValue, timeZoneObj) {<\/p>\n

\/\/get the user time zone offset value
\nvar timeZoneOffset = findTimeZoneOffset(timeZoneObj);
\nif (isValid(timeZoneOffset)) {
\ndateValue = dateValue.split(“+00:00”);
\nreturn new Date(dateValue[0] + timeZoneOffset);
\n}
\n}<\/p>\n

\/\/function call to get current daylight offset
\nfunction findTimeZoneOffset(timeZone) {
\nvar actualTimeOffset = “”;<\/p>\n

\/\/get time zone offset value
\nvar timeOffset = timeZone.timezonebias;<\/p>\n

\/\/check if daylight is present or not
\nif (timeZone.timezonedaylightday != 0 || timeZone.timezonedaylightminute != 0 || timeZone.timezonedaylightyear != 0 || timeZone.timezonedaylightsecond != 0 || timeZone.timezonedaylightdayofweek != 0 || timeZone.timezonedaylighthour != 0 || timeZone.timezonedaylightmonth != 0) {<\/p>\n

\/\/get time zone daylight value
\ntimeOffset = (timeOffset + (timeZone.timezonedaylightbias));
\n}<\/p>\n

\/\/get actual time offset according time zone
\nif (isPostiveNegative(timeOffset) == -1) {
\ntimeOffset = parseInt(timeOffset.toString().split(‘-‘)[1]);
\nvar hours = Math.floor(timeOffset \/ 60);
\nvar minutes = timeOffset % 60;
\nactualTimeOffset = “+” + (hours.toString().length == 1 ? “0” + hours : hours) + “:” + (minutes.toString().length == 1 ? “0” + minutes : minutes);
\n} else if (isPostiveNegative(timeOffset) == 1) {
\nvar hours = Math.floor(timeOffset \/ 60);
\nvar minutes = timeOffset % 60;
\nactualTimeOffset = “-” + (hours.toString().length == 1 ? “0” + hours : hours) + “:” + (minutes.toString().length == 1 ? “0” + minutes : minutes);
\n} else if (isPostiveNegative(timeOffset) == 0) {
\nvar hours = Math.floor(timeOffset \/ 60);
\nvar minutes = timeOffset % 60;
\nactualTimeOffset = “+” + (hours.toString().length == 1 ? “0” + hours : hours) + “:” + (minutes.toString().length == 1 ? “0” + minutes : minutes);
\n}
\nreturn actualTimeOffset;
\n}<\/p>\n

\/\/Check number is postive or not
\nfunction isPostiveNegative(num) {
\nreturn num === 0 ? num : (num > 0 ? 1 : -1);
\n}<\/p>\n

Conclusion<\/h2>\n

Using user Time Zone codes, we can easily find and convert time into user time.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Recently we had one requirement in which we need to set the date field by user time zone. In this requirement using javascript, the manager creates (with the help of HTML web resource) multiple Appointment entity records dynamically for different users as owner and set date field (Start Time and End Time) as per\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,19],"tags":[2101,1713,2103,2102],"class_list":["post-26141","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-crm","tag-convert-time","tag-time-zone","tag-time-zone-codes","tag-user-time"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=26141"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26141\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=26141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=26141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=26141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}