{"id":90921,"date":"2025-07-21T13:04:00","date_gmt":"2025-07-21T17:04:00","guid":{"rendered":"https:\/\/bugaluu.com\/sapiosexual\/use-today-function-in-sharepoint-list-microsoft-community-2\/"},"modified":"2025-07-21T13:04:00","modified_gmt":"2025-07-21T17:04:00","slug":"use-today-function-in-sharepoint-list-microsoft-community-2","status":"publish","type":"post","link":"https:\/\/bugaluu.com\/sapiosexual\/use-today-function-in-sharepoint-list-microsoft-community-2\/","title":{"rendered":"Use TODAY () function in SharePoint list &#8211; Microsoft Community"},"content":{"rendered":"<p>Instead of relying on TODAY () in a calculated column, you can create a custom Date field (e.g., &#8220;Today&#8217;s Date&#8221;) and use Power Automate to automatically update this field to the current date every day. You can then use this &#8220;Today&#8217;s Date&#8221; field in your calculations to determine if an item is past, today, or upcoming.<\/p>\n<p><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/use-today-function-in-sharepoint-list\/f4d73e92-7a64-4410-80df-2a15eaa272a6\" target=\"_blank\" class=\"\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/use-today-function-in-sharepoint-list\/f4d73e92-7a64-4410-80df-2a15eaa272a6<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Instead of relying on TODAY () in a calculated column, you can create a custom Date field (e.g., &#8220;Today&#8217;s Date&#8221;) and use Power Automate to&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-90921","post","type-post","status-publish","format-standard","hentry","category-sapiosexual","wpcat-1-id"],"_links":{"self":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/90921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/comments?post=90921"}],"version-history":[{"count":0,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/90921\/revisions"}],"wp:attachment":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/media?parent=90921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/categories?post=90921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/tags?post=90921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}