Create previous day's date (yesterday, 1 week ago etc.)

[MelWildridge]

AddDays(Today(), -1) to create yesterday's date.
AddDays(Today(), -7) to create the date 1 week ago.

------------------------------
Mel Wildridge
------------------------------

[RonanConsidine]

Hi Mel,

Did you have a question about this functionality or anything about the extended functionality?

It is also possible to use the DateAdd function where you can add months, quarters etc. using the right interval.

Best Regards

------------------------------
Ronan Considine
Senior Business Analyst
Blue Prism
------------------------------