Script Query

Help Studio
, , ,
1

Hello @UiPath_Community

I am creating a script where we need to do automation on SAP LogOn Pad.
Script for x system need to run on 1st Sunday of month, for y system it need to run on 3rd sunday of month and for z system it need to run on 4th sunday of month.
Can you please help me to know ho we can fetch in script that which sunday is today, is it 1st 3rd or 4th.

Thanks in Advance

2

Hi @Vaibhav_Shukla

Try this

dayOfWeek = DateTime.Now.DayOfWeek

weekNumber = (DateTime.Now.Day - 1) \ 7 + 1

If dayOfWeek.Equals("Sunday") Then
    If weekNumber = 1 Then
        Log Message: "Today is the 1st Sunday of the month."
    ElseIf weekNumber = 3 Then
        Log Message: "Today is the 3rd Sunday of the month."
    ElseIf weekNumber = 4 Then
        Log Message: "Today is the 4th Sunday of the month."
    Else
        Log Message: "Today is not the 1st, 3rd, or 4th Sunday of the month."
    End If
Else
    Log Message: "Today is not a Sunday."
End If

image
image900×2382 178 KB

Cheers!!

3

Here’s a more professional version of the C# code with improved comments and error handling:

`Code snippet///


/// Determines the ordinal occurrence (1st, 2nd, 3rd, or 4th) of the current Sunday within the current month.
///
/// The ordinal occurrence of the current Sunday (1-4), or 0 if it’s not a Sunday.
public static int GetSundayOccurrenceThisMonth()
{
// Get today’s date
DateTime today = DateTime.Today;

// Validate if it’s Sunday
if (today.DayOfWeek != DayOfWeek.Sunday)
{
// Not Sunday, find the first Sunday of the month
today = today.AddDays(- (int)today.DayOfWeek);
}

// Calculate days from the first day of the month
int daysFromFirst = today.Day;

// Handle potential overflow for months with 31 days that start on a Wednesday
if (daysFromFirst == 31 && today.DayOfWeek == DayOfWeek.Wednesday)
{
throw new InvalidOperationException(“Unexpected date combination. This method might need adjustment for some edge cases.”);
}

// Weeks passed (integer division)
int weeksPassed = daysFromFirst / 7;

// Check the remainder to determine which Sunday it is
return weeksPassed + 1;
}`

Improvements:

  • Clearer function name: GetSundayOccurrenceThisMonth clearly describes the purpose.
  • Detailed comments: Comments explain each step and potential edge cases.
  • Error handling: The code throws an InvalidOperationException for a specific edge case to avoid unexpected behavior.
  • Descriptive variable names: daysFromFirst and weeksPassed are more meaningful.

Usage with exception handling:

`Code snippettry
{
int sundayOccurrence = GetSundayOccurrenceThisMonth();

if (sundayOccurrence == 1)
{
// Run script for x system (1st Sunday)
}
else if (sundayOccurrence == 3)
{
// Run script for y system (3rd Sunday)
}
else if (sundayOccurrence == 4)
{
// Run script for z system (4th Sunday)
}
else
{
// Not a Sunday scheduled day
}
}
catch (InvalidOperationException ex)
{
// Handle potential edge case exception (log, retry, etc.)
Console.WriteLine(“An unexpected error occurred: {0}”, ex.Message);
}`

This version provides a more robust and professional solution for determining the Sunday occurrence within your SAP script automation.