https://mycommunity.validity.com/t5/demandtools/delete-how-to-create-filter-criteria-based-on-date-formula/m-p/686#M336 <P>&nbsp;</P> <P>Hi&nbsp;<a href="https://mycommunity.validity.com/t5/user/viewprofilepage/user-id/263">@jtanudja</a>,</P> <P>This functionality was recently added to the Delete module in DemandTools 5.x.&nbsp; You would use the operation of&nbsp;<SPAN>&lt; LAST_N_DAYS and the value of 729, which is two years.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnthonyValidity_0-1681408778157.png" style="width: 400px;"><img src="https://mycommunity.validity.com/t5/image/serverpage/image-id/189i604B0A7457BF8143/image-size/medium?v=v2&amp;px=400" role="button" title="AnthonyValidity_0-1681408778157.png" alt="AnthonyValidity_0-1681408778157.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnthonyValidity_1-1681408834482.png" style="width: 400px;"><img src="https://mycommunity.validity.com/t5/image/serverpage/image-id/190i0A75ACC8D39045FB/image-size/medium?v=v2&amp;px=400" role="button" title="AnthonyValidity_1-1681408834482.png" alt="AnthonyValidity_1-1681408834482.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnthonyValidity_2-1681408876036.png" style="width: 400px;"><img src="https://mycommunity.validity.com/t5/image/serverpage/image-id/191iD60A594558668DD0/image-size/medium?v=v2&amp;px=400" role="button" title="AnthonyValidity_2-1681408876036.png" alt="AnthonyValidity_2-1681408876036.png" /></span></P> <P>Hope this helps!</P> Thu, 13 Apr 2023 18:02:02 GMT AnthonyValidity 2023-04-13T18:02:02Z https://mycommunity.validity.com/t5/demandtools/delete-how-to-create-filter-criteria-based-on-date-formula/m-p/681#M335 <P>Hi!</P><P>Is there a way to create a scenario to DELETE records using date formula as its criteria?</P><P>For example, find all records created more than 2 years ago from object and then delete.</P> Wed, 12 Apr 2023 16:22:54 GMT https://mycommunity.validity.com/t5/demandtools/delete-how-to-create-filter-criteria-based-on-date-formula/m-p/681#M335 jtanudja 2023-04-12T16:22:54Z https://mycommunity.validity.com/t5/demandtools/delete-how-to-create-filter-criteria-based-on-date-formula/m-p/686#M336 <P>&nbsp;</P> <P>Hi&nbsp;<a href="https://mycommunity.validity.com/t5/user/viewprofilepage/user-id/263">@jtanudja</a>,</P> <P>This functionality was recently added to the Delete module in DemandTools 5.x.&nbsp; You would use the operation of&nbsp;<SPAN>&lt; LAST_N_DAYS and the value of 729, which is two years.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnthonyValidity_0-1681408778157.png" style="width: 400px;"><img src="https://mycommunity.validity.com/t5/image/serverpage/image-id/189i604B0A7457BF8143/image-size/medium?v=v2&amp;px=400" role="button" title="AnthonyValidity_0-1681408778157.png" alt="AnthonyValidity_0-1681408778157.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnthonyValidity_1-1681408834482.png" style="width: 400px;"><img src="https://mycommunity.validity.com/t5/image/serverpage/image-id/190i0A75ACC8D39045FB/image-size/medium?v=v2&amp;px=400" role="button" title="AnthonyValidity_1-1681408834482.png" alt="AnthonyValidity_1-1681408834482.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnthonyValidity_2-1681408876036.png" style="width: 400px;"><img src="https://mycommunity.validity.com/t5/image/serverpage/image-id/191iD60A594558668DD0/image-size/medium?v=v2&amp;px=400" role="button" title="AnthonyValidity_2-1681408876036.png" alt="AnthonyValidity_2-1681408876036.png" /></span></P> <P>Hope this helps!</P> Thu, 13 Apr 2023 18:02:02 GMT https://mycommunity.validity.com/t5/demandtools/delete-how-to-create-filter-criteria-based-on-date-formula/m-p/686#M336 AnthonyValidity 2023-04-13T18:02:02Z