topic RE: Expression to get Monday of each week in Product Forum

Expression to get Monday of each week

Miya — Wed, 07 Jul 2021 03:21:00 GMT

Hi,
I am supposed to create the file folders for each week with Monday date, basically bot should check for the current day and create the folder with this week moday. Please can anyone help to get the expression for this

------------------------------
Miya
------------------------------

RE: Expression to get Monday of each week

Vikash011 — Wed, 07 Jul 2021 05:38:00 GMT

Hi Miya,

You can use the expression - FormatDate(Today(), "ddd") .
Get the Todays Day and then you can put a choice stage and subtract the days to get this week Monday.

For Ex: FormatDate(Today(), "ddd") Result will be Wed

Based on the result you can go to the Wednesday flow and get the date by using expression - AddDays(Today(), -2)

Similarly for rest of the days. If you need Day also please use the FormatDate Expression.

Thanks,
Vikash

------------------------------
Vikash Anand
Senior Software Engineer
Ernst and Young
------------------------------

RE: Expression to get Monday of each week

sumire — Wed, 07 Jul 2021 06:00:00 GMT

This is the formula for calculating the Monday of a given day. Use code stage.(Language is Visual Basic)
Input argument is "Today", data type is Date.
Output argument is "Monday", data type is Date.
Add "mscorlib.dll" and "System.Runtime.dll" to External References.

Monday = Today.AddDays((Today.DayOfWeek - 1) * -1)

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: Expression to get Monday of each week

Miya — Wed, 07 Jul 2021 20:35:00 GMT

Thank You This code was great help

------------------------------
Miya
------------------------------