https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69594#M22199 Thanks! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Johanna Westlund<BR />RPA manager<BR />MAIK AS<BR />/Norway<BR />------------------------------<BR /> Thu, 28 Nov 2019 14:30:00 GMT johwes 2019-11-28T14:30:00Z https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69590#M22195 Hi!<BR /><BR />I need to calculate a date that is seven days back in time from todays date.&nbsp;<BR />I am fairly stuck. Anyone that can help?<BR /><BR />Appreciate any help I can get.<BR /><BR />------------------------------<BR />Johanna Westlund<BR />RPA manager<BR />MAIK AS<BR />/Norway<BR />------------------------------<BR /> Wed, 27 Nov 2019 14:36:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69590#M22195 johwes 2019-11-27T14:36:00Z https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69591#M22196 AddDays(Now(), -7)<BR /><BR />------------------------------<BR />Eric Liu<BR />RPA Developer<BR />America/Toronto<BR />------------------------------<BR /> Wed, 27 Nov 2019 14:44:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69591#M22196 EricLiu 2019-11-27T14:44:00Z https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69592#M22197 DateAdd(2, -7, Today())<BR />Or<BR />AddDays(Today(),-7)<BR /><BR />Both will work<BR /><BR />------------------------------<BR />Vivek Goel<BR />RPA Architect<BR />Asia/Singapore<BR />+6594554364<BR /><A href="https://www.rpatools.com/" target="test_blank">https://www.rpatools.com/</A><BR />------------------------------<BR /> Thu, 28 Nov 2019 08:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69592#M22197 vivek.kumar.goel 2019-11-28T08:35:00Z https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69593#M22198 Thank you! It works perfectly. It didn't occur to me to use AddDays and then use a minus in front of the number of days... Learn something new every day!<BR /><BR />------------------------------<BR />Johanna Westlund<BR />RPA manager<BR />MAIK AS<BR />/Norway<BR />------------------------------<BR /> Thu, 28 Nov 2019 14:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69593#M22198 johwes 2019-11-28T14:30:00Z https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69594#M22199 Thanks! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Johanna Westlund<BR />RPA manager<BR />MAIK AS<BR />/Norway<BR />------------------------------<BR /> Thu, 28 Nov 2019 14:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Create-a-date-7-days-back-in-time/m-p/69594#M22199 johwes 2019-11-28T14:30:00Z