Hey y’all, I have files that name consists of date like 9.10.2022-15.10.2022.xlsx and 16.10.2022-22.10.2022.xlsx … etc. For example, can we search for this file 16.10.2022-22.10.2022 in this folder name to see if it is within the date 21.10.2022?
Welcome to the community.
Yes. You can follow below steps,
Get all file names in a string array
Loop each file name and
Split file name based on - symbol
Convert split result in to date variables
Check requested/input date falls between date range
If it falls, Perform operation and break the for loop
@poorna_nayak07 could you send me an example please?
I’m sorry that I cannot share any solution files here. But following above steps would solve your problem statement.
Let me know if you find any difficulty implementing same.
I created the solution for you! Check here:
Example.xaml (12.1 KB)
thank you so much <3
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.