How to read the latest file from the Last quarter

[ahmed4566 (Syed S Ahmed)]

With reference to [How to take previous quarter in uipath]

I have a file in the shared folder and bot needs to pick the latest file from the last quarter.
link: “D:\Accounting\Finance\RealState\LeaseExpirationRports\CY24\Q1\RealState Leases\Real Estate_Lease Expiration_Q1 as of 03.19.24.xls”

shared folder path: S:\Accounting\Finance\RealState\LeaseExpirationRports

1. How to get the latest file from the last quarter?
   bot will run on mid may and has to read the latest file from last quarter (Jan-March 24)

2. And how to validate if bot runs on Jan 2025 and has to pick the file from last quarter(Oct,Nov,Dec 2024)?

[Anil_G (Anil Gorthi)]

@ahmed4566

What are your quarters ?

This is a reference for you

Date/Month format

@kaurM Please try this For quarter If({6,9,12,3}.Contains(Now.Addmonths(-1).Month),If(Now.AddMonths(-1).Month=6,"Q1", If(Now.AddMonths(-1).Month=9,"Q2", If(Now.AddMonths(-1).Month=12,"Q3","Q4"))) + "-Constant-FY",Now.Addmonths(-1).ToString("MMM-")) + If({1,2,3}.Contains(Now.AddMonths(-1).Month),Now.addMonths(-1),Now.addmonths(-1).Addyears(1)).ToString("yy") Hope this helps Cheers

Cheers

[ahmed4566 (Syed S Ahmed)]

Bro I got the solution with the different approach but u tried so I appreciate that.