Select week and date

Screenshot (22)
Can any one help me regarding this ? How I can select This type of date and week wise in UIPath ?

HI @Charan_cherry

Welcome to the community!

If you can tyope the date manually there,then you can use type into to write the date there

and you can also use this expression to get the week number and add this in type into to write in that field

If(System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek).ToString.Length=1,"0"+System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek).ToString,System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek).ToString)

Regards
Sudharsan

Thank you @Sudharsan_Ka , but I have 12 employee names , I download 12 employees Timesheet in one week, how can I select for next week can I repeat same typeinto for next week Also, can you help me once.

Yes you can use same type into you need to enable empty field property in the type into activity so that how many time it came to write the next week or date it will delete the already entered value and write the new one @Charan_cherry

Regards
Sudharsan

Thank you @Sudharsan_Ka ,I will try.

Hello @Charan_cherry

Can you directly type the week and date or do you need to select it from the date picker? If need to select from date picker, then you need to pass the value as variable to the selector to choose the respective date.

Thanks

Thankyou @Rahul_Unnikrishnan ,but I have week in left side

Hi Charan,
If you can type in that field then use this command to get the Week number
Math.Ceiling(DateTime.Today.DayOfYear / 7)

Is Typing working? If not, as how we are selecting the day, we need to automate the month as well using a dynamic variable.

Thanks

Have you tried the above steps which i suggest @Charan_cherry ?

I strucked in For each row in data table. how can i get employee names from excel sheet and select that employee and download time sheet


Can you help this @Sudharsan_Ka .

Do you face any error? @Charan_cherry

No, but it looping only one name actually i have 12 employee names @Sudharsan_Ka

Thankyou @pratik.santani

Select Item activity will not have such properties @Charan_cherry

Hello, I was able to make a robot selection when I followed the steps on this site, you can try it too.

ThankYou @ceyda_eren

1 Like

You’re welcome. If it solves your problem could you please mark as solution?