New Date query

Help Studio
1

I have 2 date’s - Start Dt & End Dt

Condition-

start date should be 2 days prior than end date

Eg-
Cond1:- If Today is Monday then

Start date should be- Oct 31, 2024
End date should be - Nov 1, 2024

Cond2:- if Today is Tuesday(Nov 5, 2024) then

Start date should be - Nov 1, 2024
End date should be - Nov 4, 2024

Cond3:- If Today is Wednesday(Nov 6, 2024) then

Start date should be - Nov 4, 2024
End date should be - Nov 5, 2024

Struggling in condtion2.

Using below code, it is working for condition 1 only.
start dt- Today.AddDays(7*CInt(Today.DayOfWeek<=DayOfWeek.Friday)+(DayOfWeek.Friday-Today.DayOfWeek)-1).ToString(“MMM dd, yyyy”)

Anyone can suggest

2

@Jeeru_venkat_Rao,

Try this logic using Switch case.

Variables:

  • today (DateTime) = DateTime.Now
  • startDate (DateTime)
  • endDate (DateTime)

Activities:

  1. Switch (today.DayOfWeek)
    Cases:
    • DayOfWeek.Monday:
      • Assign endDate = today.AddDays(1)
      • Assign startDate = endDate.AddDays(-2)
    • DayOfWeek.Tuesday:
      • Assign endDate = today.AddDays(-1)
      • Assign startDate = endDate.AddDays(-2)
    • DayOfWeek.Wednesday:
      • Assign endDate = today.AddDays(-1)
      • Assign startDate = endDate.AddDays(-2)
    • Default:
      • Handle other days if needed

LLM helped me to write this but it’s validated by me.

3

Thanks @ashokkarale . I am using elseif activity and output is coming. Which is better should I go for switch or Else If?

4

@Jeeru_venkat_Rao,

It depends on your choice but I would suggest to use Switch due to its readability and simplicity.

Cheers!!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.