{"id":4261,"date":"2024-09-18T13:26:09","date_gmt":"2024-09-18T13:26:09","guid":{"rendered":"https:\/\/geekmungus.co.uk\/?p=4261"},"modified":"2024-09-18T13:26:10","modified_gmt":"2024-09-18T13:26:10","slug":"monday-com-cheeky-before-date-formula","status":"publish","type":"post","link":"https:\/\/geekmungus.co.uk\/?p=4261","title":{"rendered":"Monday.com Cheeky Before Date Formula"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I had a need to be able to show up a row if a date in that row had fallen out of compliance, e.g. list of assets, with a &#8220;Last Patch&#8221; date on it. If the &#8220;Last Patch&#8221; date is more than X days (e.g. 90 days) before today, then show it up.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At the time of writing there is a feature request in for being able to do NOT &#8220;in the last&#8221; X &#8220;days&#8221;, but currently that is not available.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So you can use a formula to do this, so create a formula then you create the filter as shown to refer to the &#8220;Last Patch&#8221; column or whatever you want to call it.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>IF(FORMAT_DATE({Last Patch},\"YYYYMMDD\")&lt;FORMAT_DATE(SUBTRACT_DAYS(TODAY(),90),\"YYYYMMDD\"),\"Attention\",\"OK\")<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Now you can use that column in whatever normal filter you wish!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I had a need to be able to show up a row if a date in that row had fallen out of compliance, e.g. list of assets, with a &#8220;Last Patch&#8221; date on it. If the &#8220;Last Patch&#8221; date is more than X days (e.g. 90 days) before today, then show it up. At the &#8230; <a title=\"Monday.com Cheeky Before Date Formula\" class=\"read-more\" href=\"https:\/\/geekmungus.co.uk\/?p=4261\" aria-label=\"Read more about Monday.com Cheeky Before Date Formula\">Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-4261","post","type-post","status-publish","format-standard","hentry","category-random"],"_links":{"self":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/4261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4261"}],"version-history":[{"count":1,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/4261\/revisions"}],"predecessor-version":[{"id":4262,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/4261\/revisions\/4262"}],"wp:attachment":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}