dateTime Help

[PurpleLama (Dylan)]

Hi I would love some help with dateTime
When I collect the information from Excel and it’s a Monday I also need to include the previous Saturday and the Friday.

How would i express this

[Gokul_Jayakumar (Gokul Jai)]

Hello @PurpleLama , You can use Modify date activity, its may helps for your requirement

[Akash_Khobare (Akash Suresh Khobare)]

Hello @Gokul_Jayakumar,

You can use Modify Date activity in order to shift one date before or after as per requirement.

Make sure you use check “Format Output as Text” and select you desired ***day format.

You can also you string manipulation to convert only the ***day method you want.

[PurpleLama (Dylan)]

Thank you so much, ill try this today.

[PurpleLama (Dylan)]

Thank you will also use this today