Hi Team,
Need your help to open previous day file dynamically.
user keep all input file with below standard folder structure day wise.
D:\2020\09. Sep 2020\Credit_Card\01.09.2020\abc_01.09.2020.xlsx
to choose Previous day file I can go one day back using dateadd function. It works.
But if month changes Previous day file will be one day back i.e Previous months Last working day file.
How to achieve this task . Need help!
Folder :=>D:\2020\09. Sep 2020\Credit_Card\01.09.2020\abc_01.09.2020.xlsx
yyyy\mm. mmm yyyy\Credit_Card\dd.mm.yyyy\abc_dd.mm.yyyy.xlsx
My system date dd/mm/yyyy format.
added SnapShot of my systems folder structure
Thanks
mg
Need your help to open previous day file dynamically.
user keep all input file with below standard folder structure day wise.
D:\2020\09. Sep 2020\Credit_Card\01.09.2020\abc_01.09.2020.xlsx
to choose Previous day file I can go one day back using dateadd function. It works.
But if month changes Previous day file will be one day back i.e Previous months Last working day file.
How to achieve this task . Need help!
Folder :=>D:\2020\09. Sep 2020\Credit_Card\01.09.2020\abc_01.09.2020.xlsx
yyyy\mm. mmm yyyy\Credit_Card\dd.mm.yyyy\abc_dd.mm.yyyy.xlsx
My system date dd/mm/yyyy format.
added SnapShot of my systems folder structure
Thanks
mg