How to use 'Move File' (or any other suggestion) to move and rename the file according to workweek and time?

Help
, ,
1

Hi, I’m new here. Need some guidance into using Move File, or any that you can suggest.
I need to move a file from one location to another. At the same time, I need to rename the file according to workweek and time.
Example:
Original: AAA.xlsx
Rename to: AAA**_WW49.5_8am**.xlsx

WW49.5 - this will be based on what workweek and day we run the robot.
8am / 2pm - this will be based on if the robot runs before 2pm, then the label will be ‘8am’. If the robot runs after 2pm, then the label will be ‘2pm’.

3

@Bonus,

Welcome to UiPath Community.

You can use Move File activity.

For the week number use this function - CInt(DateTime.Now.DayOfWeek)
For the Hour logic use this code - If(Now.Date.Hour <= 14, “8.AM”, “2.PM”)

Import the below two Namespace in your workflow int he Imports section.
Imports System.Globalization
Imports System.IO

Create a variable as cal with datetype of CultureInfo.InvariantCulture.Calendar
After that, the below code will give you the expected result.
Path.GetFileNameWithoutExtension(“C:\Users\yourUserName\Desktop\AAA.xlsx”) + “" + Convert.ToString(CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(Now.Date, CalendarWeekRule.FirstDay, DayOfWeek.Monday)) + “.” + Convert.ToString(CInt(DateTime.Now.DayOfWeek)) + "” + Convert.ToString(If(Now.Date.Hour <= 14, “8.AM”, “2.PM”)) + “.xlsx”

2 Likes
4

Hi Bonus, here are the hints that will help you to achieve it…

  1. To get the work week (assumed as week of the year): CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(Date.Now, CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule, CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek)

Note: We need to import System.Globalization for this.

  1. To get the day (assumed as day of the week): Please use “DayOfWeek” of DateTime class & convert it into int datatype.

  2. We can get the hour of the current time & add a condition to check if it’s before or after 2pm.

Finally we can merge the above as a new filename that you would like to move it to a new location using “Move File” activity.

Let me know if this helps…

1 Like
5

Thanks. It works :smiley:
For the hour logic, I tried this one:
Convert.ToString(If(DateTime.Now.Hour <= 14,“8am”,“2pm”))

6

Thanks. :smiley:

1 Like
7

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