Im currently opening an excel sheet that has a date in the name, and it is sent out every monday.
The current method i am using =
Assign activity : [currentDate] = [DateTime.Now.ToString(“yyyy-MM-dd”)]
Then i open the excel which is something like “Report-2018-06-14.xlsx” in the following manner =
"\resources\Report-" + currentDate + ".xlsx"
Which works great if I want to only open today’s report. the problem is the report might come in on a Monday or a Tuesday, so I was thinking of running the bot on a Weds.
as the report can come on a monday or tuesday i need a range of days, ideally like “Today + last 2 days”
"\resources\Report-" + currentDate (-2) + ".xlsx"
but it didn’t work. I’ve also tried changing the assign & various other ways from google but i just cant seem to get it working.
any ideas? do i have to do the entire process in a differnt way to achieve this?