Get start and end of week in Workflow

6 years ago
2 February 2018
1 reply
3 views

+2

jhong88
9 replies

Hi Everyone

is there to get the start and end of the week if given current date?

for example, if I use Feb 02, 2018, I want to get the start of the week to be January 29, 2018 (Monday) and the end of the week to be Feb 4, 2018 (Sunday).

and may be as an extension of that, how would I go about getting the start and end of the previous week?

for example, if I use Feb 02, 2018, I want to get the start of the week to be January 22, 2018 (Monday) and the end of the week to be January 28, 2018 (Sunday).

what I'm trying to do is create a workflow to generate a report for the previous week. Right now I'm using Current date - 1 and current day - 7, but if I run the job for anything other then the Monday, it would return the incorrect date. I would like to allow the job to run on any day and still pick up the current or Previous week.

Thanks