I have to get previous created folder

[shaik.muktharvalli1 (shaik muktharvalli)]

Hi all, My BOT generated daily back folder but I have to get previous Created folder from my backup folders

Any one please

Thanks
Shaik Muktharvalli

[Gokul001 (Gokul Balaji)]

Hi @shaik.muktharvalli1

This expression would get you the latest file

Str_Path = Directory.GetFiles(yourfolder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Tolist(0)

Directory.GetDirectories("yourdirectorypath").[Select](Function(d) New DirectoryInfo(d)).Where(Function(d) d.CreationTime.Date.Equals(Datetime.Now.Date)).ToList()

Regards
Gokul

[Parvathy (PS Parvathy)]

Hi @shaik.muktharvalli1

1. Get Current Date:
   Use the Now function to get the current date. Assign this value to a variable, e.g., currentDate.
2. Calculate Previous Date:
   Subtract one day from the current date to get the previous date. You can do this using the AddDays function.

   Assign activity:
   previousDate = currentDate.AddDays(-1)

3. Format Date as String:
   Convert the previous date to a string with the desired format (e.g., “yyyyMMdd”). You can use the ToString function for this.

   Assign activity:
   previousDateString = previousDate.ToString("yyyyMMdd")

4. Build the Path to the Previous Backup Folder:
   Assuming that your backup folders are named using the date (e.g., “Backup_20231011”), you can now construct the path to the previous backup folder by concatenating the folder base path and the previousDateString variable.

   Assign activity:
   backupFolderPath = "C:\YourBackupBasePath\Backup_" + previousDateString

5. Check if the Folder Exists:
   To ensure that the folder exists before accessing it, you can use the Directory.Exists function. If the folder exists, proceed with your backup operations.

   If (Directory.Exists(backupFolderPath)) Then
       ' Access the previous day's backup folder
   Else
       ' Handle the case where the folder does not exist
   End If

6. Access the Previous Backup Folder:
   Within the “If” block where the folder exists, you can perform any operations needed on the previous day’s backup folder.

Hope it helps!!

[supriya117 (Supriya Allada)]

Hi @shaik.muktharvalli1

backupFolder = "C:\YourBackupFolder"
out_backupFolder = Directory.GetDirectories(backupFolder).OrderByDescending(Function(x) DateTime.ParseExact(Path.GetFileName(x), "yyyyMMdd", CultureInfo.InvariantCulture)).FirstOrDefault()

[shaik.muktharvalli1 (shaik muktharvalli)]

not latest file , i have to get previous latest folder

[Gokul001 (Gokul Balaji)]

@Gokul001

Directory.GetDirectories("yourdirectorypath").[Select](Function(d) New DirectoryInfo(d)).Where(Function(d) d.CreationTime.Date.Equals(Datetime.Now.Date)).ToList()

Check out this? @shaik.muktharvalli1

[shaik.muktharvalli1 (shaik muktharvalli)]

for your calrity

I have to get previous updated folder ( In image one folder generated 8:38AM and another one generated 8:39AM) then I have to get previous one means 8:38AM folder

[lrtetala (Lakshman Reddy)]

Hi @shaik.muktharvalli1

Folders=Directory.GetDirectories("C:\Users\lrtetala\Documents\UiPath\BlankProcess12\New folder")

SortedFolders=Folders.OrderBy(Function(dir) New DirectoryInfo(dir).LastWriteTime).First

Hope this helps!!

[Gokul001 (Gokul Balaji)]

Check out this thread @shaik.muktharvalli1

Get the latest created folder's creation date from a directory

please try this: DirectoryInfo latestfolder = new DirectoryInfo(path).GetDirectories("*",SearchOption.AllDirectories).OrderByDescending(function(d) d.CreationTime).First(); it will return the latest created folder(last modified) directory. and let me know and to get folder name and with date of creation see the attached sample. Reference: latestdirdate.xaml (5.2 KB)

[lrtetala (Lakshman Reddy)]

@shaik.muktharvalli1

Please check on this xaml

BlankProcess12.zip (55.2 KB)

Cheers!!

[shaik.muktharvalli1 (shaik muktharvalli)]

@Gokul001

Directory.GetDirectories(“yourdirectorypath”).[Select](Function(d) New DirectoryInfo(d)).Where(Function(d) d.CreationTime.Date.Equals(Datetime.Now.Date)).ToList()

can you vaibales type please

[shaik.muktharvalli1 (shaik muktharvalli)]

can you show vaibales type please

[lrtetala (Lakshman Reddy)]

@shaik.muktharvalli1

[lrtetala (Lakshman Reddy)]

@shaik.muktharvalli1

Here is the latest folder

[shaik.muktharvalli1 (shaik muktharvalli)]

please run this subfolders then i have to get “New Folder 2” because its previous updated folder

[lrtetala (Lakshman Reddy)]

@shaik.muktharvalli1

Try this

Please find the below xaml

BlankProcess12.zip (57.4 KB)

Hope this helps!!

[lrtetala (Lakshman Reddy)]

@shaik.muktharvalli1

Folders=Directory.GetDirectories("C:\Users\lrtetala\Documents\UiPath\BlankProcess12\New folder")

SortedFolders=Folders.OrderBy(Function(dir) New DirectoryInfo(dir).LastWriteTime).ToArray()

MsgBox:SortedFolders(1)

[shaik.muktharvalli1 (shaik muktharvalli)]

Not working bro…it taking another folder not take excepted folder

[lrtetala (Lakshman Reddy)]

@shaik.muktharvalli1

Can you share screenshot of your process workflow or xaml because it is working for me

Once confirm the below result you wanted

I have to get previous created folder

@shaik.muktharvalli1 Try this [image] [image] Please find the below xaml BlankProcess12.zip (57.4 KB) Hope this helps!!

[shaik.muktharvalli1 (shaik muktharvalli)]