{"id":869,"date":"2013-05-21T16:04:52","date_gmt":"2013-05-21T23:04:52","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=869"},"modified":"2023-02-24T21:48:44","modified_gmt":"2023-02-24T21:48:44","slug":"calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/","title":{"rendered":"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View"},"content":{"rendered":"<p>Let\u2019s say you\u2019d like to create a custom list that had a calendar view associated with it.&nbsp; And in that list, you wanted to emulate what the SharePoint calendar list does (which is to pre-calculate the End Date \/ End Time for you).&nbsp; How does one do such a thing?<\/p>\n<p>Basically, I\u2019m referring to how to calculate the below field.&nbsp; <\/p>\n<p><a href=\"https:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top: 0px;border-right: 0px;border-bottom: 0px;padding-top: 0px;padding-left: 0px;border-left: 0px;padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png\" width=\"625\" height=\"376\"><\/a><\/p>\n<p>Note that to get the Start Date \/ Start Time, SharePoint will actually do this for you, by selecting \u201cToday\u2019s Date\u201d.<\/p>\n<p><a href=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/SNAGHTML175219b.png\"><img loading=\"lazy\" decoding=\"async\" title=\"SNAGHTML175219b\" style=\"border-top: 0px;border-right: 0px;border-bottom: 0px;padding-top: 0px;padding-left: 0px;border-left: 0px;padding-right: 0px\" border=\"0\" alt=\"SNAGHTML175219b\" src=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/SNAGHTML175219b_thumb.png\" width=\"320\" height=\"369\"><\/a><\/p>\n<p>End date (or end time) is the more complicated one.&nbsp; Here\u2019s the SP formula for calculating it.<\/p>\n<p>=Today+(ROUNDUP(NOW.TIME()*24,0)\/24)+(1\/24)<\/p>\n<p>Basically, this equates to:<\/p>\n<p>Today (if you don\u2019t include this, your date starts back in 1899), plus the time right now rounded up to the next hour (the middle funkiness), plus an extra hour (1\/24).<\/p>\n<p><a href=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/SNAGHTML1786722.png\"><img loading=\"lazy\" decoding=\"async\" title=\"SNAGHTML1786722\" style=\"border-top: 0px;border-right: 0px;border-bottom: 0px;padding-top: 0px;padding-left: 0px;border-left: 0px;padding-right: 0px\" border=\"0\" alt=\"SNAGHTML1786722\" src=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/SNAGHTML1786722_thumb.png\" width=\"283\" height=\"419\"><\/a><\/p>\n<p>Now you no longer need the SP Calendar list to do this for you, especially if you don\u2019t want all the integration points that come with the SP Calendar list.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Let\u2019s say you\u2019d like to create a custom list that had a calendar view associated with it.&nbsp; And in that list, you wanted to emulate what the SharePoint calendar list does (which is to pre-calculate the End Date \/ End Time for you).&nbsp; How does one do such a thing? Basically, I\u2019m referring to how &hellip; <a href=\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/\"><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[7],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View - Archive\" \/>\n<meta property=\"og:description\" content=\"Let\u2019s say you\u2019d like to create a custom list that had a calendar view associated with it.&nbsp; And in that list, you wanted to emulate what the SharePoint calendar list does (which is to pre-calculate the End Date \/ End Time for you).&nbsp; How does one do such a thing? Basically, I\u2019m referring to how &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-21T23:04:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:48:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/\",\"name\":\"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png\",\"datePublished\":\"2013-05-21T23:04:52+00:00\",\"dateModified\":\"2023-02-24T21:48:44+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#primaryimage\",\"url\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png\",\"contentUrl\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View - Archive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/","og_locale":"en_US","og_type":"article","og_title":"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View - Archive","og_description":"Let\u2019s say you\u2019d like to create a custom list that had a calendar view associated with it.&nbsp; And in that list, you wanted to emulate what the SharePoint calendar list does (which is to pre-calculate the End Date \/ End Time for you).&nbsp; How does one do such a thing? Basically, I\u2019m referring to how &hellip;","og_url":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/","og_site_name":"Archive","article_published_time":"2013-05-21T23:04:52+00:00","article_modified_time":"2023-02-24T21:48:44+00:00","og_image":[{"url":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png"}],"author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/","url":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/","name":"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#primaryimage"},"thumbnailUrl":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png","datePublished":"2013-05-21T23:04:52+00:00","dateModified":"2023-02-24T21:48:44+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#primaryimage","url":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png","contentUrl":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/05\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2013\/05\/21\/calculating-the-sharepoint-end-date-time-for-a-custom-list-with-a-calendar-view\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"Calculating the SharePoint End Date \/ Time for a Custom List with a Calendar View"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/869"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=869"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/869\/revisions"}],"predecessor-version":[{"id":1931,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/869\/revisions\/1931"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}