{"id":11081,"date":"2024-01-30T19:54:33","date_gmt":"2024-01-30T18:54:33","guid":{"rendered":"https:\/\/help.metashare.com\/?page_id=11081"},"modified":"2024-09-19T16:20:13","modified_gmt":"2024-09-19T14:20:13","slug":"word-online-can-show-wrong-dates-in-quick-parts","status":"publish","type":"page","link":"https:\/\/staging-help.metashare.com\/en\/metashare\/known-issues\/other\/word-online-can-show-wrong-dates-in-quick-parts\/","title":{"rendered":"Word Online can show wrong dates in Quick Parts"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><a href=\"https:\/\/staging-help.metashare.com\/en\/metashare\/known-issues\/other\/document-filter-does-not-filter-on-correct-tags\/#description\"><\/a>Description<\/h2>\n\n\n\n<p>Depending on which time-zone you are located in, Word Online can show date values in Quick Parts one day off, compared to the date that is set in the document&#8217; property (metadata). If you open a document\u2019s details pane to see a preview of the document or if you select the \u201cPreview\u201d function, available under the ellipsis icon you will have the same issue. In Word&#8217;s desktop client the date will however be shown correctly.<\/p>\n\n\n\n<p>Here you see the date (2023-12-13) in a document&#8217;s property form in SharePoint:<br><img loading=\"lazy\" decoding=\"async\" width=\"319\" height=\"765\" class=\"wp-image-11092\" style=\"width: 250px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-in-SharePoint.png\" alt=\"Document properties in SharePoint\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-in-SharePoint.png 319w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-in-SharePoint-125x300.png 125w\" sizes=\"auto, (max-width: 319px) 100vw, 319px\" \/><\/p>\n\n\n\n<p>The date is shown correctly in Word&#8217;s desktop client:<br><img loading=\"lazy\" decoding=\"async\" width=\"1286\" height=\"427\" class=\"wp-image-11083\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Word-Desktop-client.png\" alt=\"Document properties - Word Desktop client\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Word-Desktop-client.png 1286w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Word-Desktop-client-300x100.png 300w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Word-Desktop-client-1024x340.png 1024w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Word-Desktop-client-768x255.png 768w\" sizes=\"auto, (max-width: 1286px) 100vw, 1286px\" \/><\/p>\n\n\n\n<p>But not when opening a preview of the document:<br><img loading=\"lazy\" decoding=\"async\" width=\"1258\" height=\"177\" class=\"wp-image-11085\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Preview.png\" alt=\"Document properties - Preview\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Preview.png 1258w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Preview-300x42.png 300w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Preview-1024x144.png 1024w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Document-properties-Preview-768x108.png 768w\" sizes=\"auto, (max-width: 1258px) 100vw, 1258px\" \/><\/p>\n\n\n\n<p>Or in Word Online:<br><img loading=\"lazy\" decoding=\"async\" width=\"1114\" height=\"220\" class=\"wp-image-11089\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Word-Online-quick-part-values.png\" alt=\"Word Online quick part values\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Word-Online-quick-part-values.png 1114w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Word-Online-quick-part-values-300x59.png 300w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Word-Online-quick-part-values-1024x202.png 1024w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Word-Online-quick-part-values-768x152.png 768w\" sizes=\"auto, (max-width: 1114px) 100vw, 1114px\" \/><\/p>\n\n\n\n<p>The date in Word Online is shown in the time-zone for Seattle, Washington, USA (UTC-08:00), so if the time-zone in your SharePoint site e.g. is UTC+01:00, Word Online will show the date 9 hrs prior to the set date (when a date column is defined to only show date and not time, the time for the date will be 00:00, so then the date will be presented the day before at 15:00).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a href=\"https:\/\/staging-help.metashare.com\/en\/metashare\/known-issues\/other\/document-filter-does-not-filter-on-correct-tags\/#solution-workaround\"><\/a>Solution\/workaround<\/h2>\n\n\n\n<p>The only way to ensure that correct dates are shown in date field Quick Parts is to open the documents in Word&#8217;s desktop client.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a href=\"https:\/\/staging-help.metashare.com\/en\/metashare\/known-issues\/other\/document-filter-does-not-filter-on-correct-tags\/#expected-fix\"><\/a>Expected fix<\/h2>\n\n\n\n<p>We have communicated this issue to Microsoft and unfortunately their response is that this is by design and that it\u2019s not probable that they will fix this issue in the near future.<\/p>\n\n\n\n<div class=\"wp-block-group has-text-bright-color has-accent-1-background-color has-text-color has-background has-link-color wp-elements-5715d999d759a44a854d1a0508fae595\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h2 class=\"wp-block-heading has-text-bright-color has-text-color has-link-color wp-elements-d1bac14c5327bf7abb712f1154155733\">Discover MetaShare<\/h2>\n\n\n\n<p>Metadata-centric document management system in Microsoft 365\/SharePoint<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Eliminates annoying gaps in standard SharePoint<\/li>\n\n\n\n<li>Ensures data in SharePoint is well structured<\/li>\n\n\n\n<li>Structures with metadata instead of storing in traditional folders<\/li>\n\n\n\n<li>Centralized and simplified administration<\/li>\n\n\n\n<li>Orchestration\/provisioning of settings<\/li>\n\n\n\n<li>Refined Enterprise search<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/metashare.com\/en\/demo\/\">See demo<\/a><\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Depending on which time-zone you are located in, Word Online can show date values in Quick Parts one day off, compared to the date that is set in the document&#8217; property (metadata). If you &#8230; <a title=\"Word Online can show wrong dates in Quick Parts\" class=\"read-more\" href=\"https:\/\/staging-help.metashare.com\/en\/metashare\/known-issues\/other\/word-online-can-show-wrong-dates-in-quick-parts\/\" aria-label=\"Read more about Word Online can show wrong dates in Quick Parts\">Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"parent":10756,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":{"0":"post-11081","1":"page","2":"type-page","3":"status-publish","5":"no-featured-image-padding"},"_links":{"self":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/11081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/comments?post=11081"}],"version-history":[{"count":7,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/11081\/revisions"}],"predecessor-version":[{"id":11306,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/11081\/revisions\/11306"}],"up":[{"embeddable":true,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/10756"}],"wp:attachment":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/media?parent=11081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}