All weekdays of a month

Help Studio
1

How can I design a robot that prints all days from the first day of the month to the last day of the month (dd/MM/yyyy) except Saturday and Sunday? I dont want to see day of weekend.

2

Hi,

Do you need single string as result? If so, the following helps you.

img20210912-3
img20210912-3883×469 24.3 KB 

String.Join(vbCrLf,Enumerable.Range(1,DateTime.DaysInMonth(targetDate.Year,targetDate.Month)).Select(Function(i) New DateTime(targetDate.Year,targetDate.Month,i)).Where(Function(d) d.DayOfWeek <>DayOfWeek.Sunday AndAlso d.DayOfWeek <>DayOfWeek.Saturday).Select(Function(d) d.ToString("dd/MM/yyyy")))

Regards,

1 Like
3

thank u it worked

1 Like
4

can u code list for startdate? for each item in writeline:
startdate

5

Hi,

Do you need list<String> as result? The following might help you.

img20210912-4
img20210912-4706×363 12.7 KB 

Enumerable.Range(1,DateTime.DaysInMonth(targetDate.Year,targetDate.Month)).Select(Function(i) New DateTime(targetDate.Year,targetDate.Month,i)).Where(Function(d) d.DayOfWeek <>DayOfWeek.Sunday AndAlso d.DayOfWeek <>DayOfWeek.Saturday).Select(Function(d) d.ToString("dd/MM/yyyy")).ToList

Regards,

1 Like
6

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