https://community.blueprism.com/t5/Product-Forum/Create-previous-day-s-date-yesterday-1-week-ago-etc/m-p/49325#M4749 <P>Hi Mel,<BR /><BR />Did you have a question about this functionality or anything about the extended functionality?</P> <P>It is also possible to use the DateAdd function where you can add months, quarters etc. using the right interval.<BR /><BR />Best Regards</P><BR /><BR />------------------------------<BR />Ronan Considine <BR />Senior Business Analyst<BR />Blue Prism<BR />------------------------------<BR /> Wed, 16 Nov 2022 13:39:00 GMT RonanConsidine 2022-11-16T13:39:00Z https://community.blueprism.com/t5/Product-Forum/Create-previous-day-s-date-yesterday-1-week-ago-etc/m-p/49324#M4748 AddDays(Today(), -1) to create yesterday's date.<BR />AddDays(Today(), -7) to create the date 1 week ago.<BR /><BR />------------------------------<BR />Mel Wildridge<BR />------------------------------<BR /> Fri, 19 Aug 2022 11:59:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-previous-day-s-date-yesterday-1-week-ago-etc/m-p/49324#M4748 MelWildridge 2022-08-19T11:59:00Z https://community.blueprism.com/t5/Product-Forum/Create-previous-day-s-date-yesterday-1-week-ago-etc/m-p/49325#M4749 <P>Hi Mel,<BR /><BR />Did you have a question about this functionality or anything about the extended functionality?</P> <P>It is also possible to use the DateAdd function where you can add months, quarters etc. using the right interval.<BR /><BR />Best Regards</P><BR /><BR />------------------------------<BR />Ronan Considine <BR />Senior Business Analyst<BR />Blue Prism<BR />------------------------------<BR /> Wed, 16 Nov 2022 13:39:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-previous-day-s-date-yesterday-1-week-ago-etc/m-p/49325#M4749 RonanConsidine 2022-11-16T13:39:00Z