How to dynamically pick the date from the below mentioned format

Help Automation Ops
,
10

Hi @anjani_priya

If you are asking dynamically based on Input Date. Here is one approach:

day = "13-12-2024"
dayDateTime = DateTime.ParseExact(day, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)
lastDay = New DateTime(dayDateTime.Year, dayDateTime.Month, 1).AddDays(-1)
lastDayOfMonth = If( lastDay.DayOfWeek = System.DayOfWeek.Saturday OrElse lastDay.DayOfWeek = System.DayOfWeek.Sunday, lastDay.AddDays(-1).ToString("dd-MM-yyyy"), lastDay.ToString("dd-MM-yyyy"))

There is no need of 4 different variables. You can manage with just 2. But i have made 4 for readability:

This image shows a table listing variables with their names, types, and scopes in a software sequence. (Captioned by AI)
This image shows a table listing variables with their names, types, and scopes in a software sequence. (Captioned by AI)737×158 3.72 KB

THE OUTPUT:

image
image525×129 3.84 KB

If this solves your issue, Do mark it as a solution
Happy Automation :star_struck:

1 Like