Finding the starting business date of the given date

[Betul_Dundar (Betül Dündar)]

For example todays’ date is 18.04.2024. How to find starting work day which is 15.04.2024

Weekend is saturday and sunday

Could you please help me?

[Gautham_Pattabiraman]

Hi @Betul_Dundar ,

To find the date of monday (Start of work week) , in an assign activity use the below

LHS :
MondayDate(string variable)
RHS:
DateTime.Today.AddDays(-(today.DayOfWeek - DayOfWeek.Monday)).ToString(“yyyy-MM-dd”)

Hope this helps you out.!

Thanks,
Gautham.

[Shiva_Nikhil]

@Betul_Dundar

Try this

now.AddDays(-CInt(now.DayOfWeek)+1)

[Akshay_B]

Hello @Betul_Dundar ,

I have attached below the Screenshot of the Code:

I hope this helps.
Regards;)

[Betul_Dundar (Betül Dündar)]

@Gautham_Pattabiraman

DateTime.Today.AddDays(-(today.DayOfWeek - DayOfWeek.Monday)).ToString(“yyyy-MM-dd”)

Thank you! @Gautham_Pattabiraman

[MD_Farhan1 (MD Farhan)]

Change Date Format in text field

Hi, i have one excel file get data and type into web text field. in excel date is dd/mm/yyyy but type in to text field dd/mm/yyyy ss:mm:hh how to solve this is pls any one solve this issue. [Screenshot 2024-04-18 143524] [Screenshot 2024-04-18 143643]

pls give me a solution