How to get specific holiday date basis on holiday sheet

Help Activities
,
1

Hi l Everyone,

I have to download file and that file available on some of holidays. So how i can download that file, even maintaining the holiday list which days file is available.

For example on 15 Aug officially holiday but on that day file is available so bot will run on next working day and download file of 15th aug
Thanks.

2

@suraj_gaikwad

As per basic understanding of your use case, I think you can add timestamp to your file.

Have trigger placed to run on working days only.

Maintain a file with dates on which your report will be available.

In bot logic add a checkpoint to check for every past date you should have a downloaded file. If the file isn’t there, but should be downloading that file.

This should work in every possible situation.

3

Hi @ashokkarale ,

Yes, But the file name is on date base and i have to download regular file wich is working day also. Bot run every day mon to fridays, this scenario happens only few days wich is on some specific holiday and those date i stored in csv file

Thanks

4

@suraj_gaikwad

for stopping bot specifically for trigger you need to uplaod csv and select that as holiday calendar

from the bot perspective you can add an asset to check the last rundate and add the last run date in asset and then when you run again check all date between last run date and todays date ..so that any missed file is captured

cheers

5

Hi @Anil_G

Not using asset,

So basically what I’m doing, getting last working day and current date, Between these two dates then I’m comparing the dates from csv file which i stored.

Thank you

6

@suraj_gaikwad

okay then read the file …get last working data in loop just use filter or linq query to check of the date matches and then run accordingly

cheers

7

Okay, So basically i have to holiday file list one is for all Holiday and other is only those specific holidays.

Thanks

8

@suraj_gaikwad

You can read any number of dates or files as you need the concept remains same..check with those files with filter or linq

cheers

9

Once i read then how i can check of every date is matching or not?

10

@suraj_gaikwad

say lastworkingdate is a datevariable

lastworkingdate.adddays(1) will give next date

now dt.AsEnumerable.Where(function(x) CDaate(x(0).ToString).ToString("MM/dd/yyyy").equals(lastworkingdate.adddays(1).ToString("MM/dd/yyyy"))).Count>0

here dt is datatable containing all dates

instead of adddays(1) you need to do in loop with variable and also check if the lastworkingdate.adddays(x) is equal to current date and end the loop

cheers

11

Ok ! But what if the fri,sat,sun and Monday is holiday and file available on Friday, then what happen in thise case

@Anil_G
These dates are holiday
8/27/25
10/22/25
11/05/2025

Need to download file on above days.

Thanks

12

@suraj_gaikwad

i dont get your question…last working date are you calculating?

if yes then go with asset approach so you know the exact last date of run

cheers

13

Ok ! So i don’t want to download file basis on last working day. I have to download the file on holidays which is available on some specific holidays. Wich i mentioned the dates.

For example on 15th aug is officially holiday and bot run on 16th but file is available on 15th then download the file of 15th aug.

@Anil_G

Thanks

14

@suraj_gaikwad

so does you bot run on weekends?

if not also you want weekend to be considered if weekend falls on holiday?

is that the ask?

if you need to download based on date of holidays also get last workign date and find holidays between last working day and today..thsoe are the dates you need

cheers