M
I will get hldy list in excel
https: //date. nager. at/Api
Remove space frm above URL
Size: a a a
2021 July 20
VG
VG
No its get API
VG
1st ask BA/sme/cleint is it ok to involve 3rd party API
M
Noo
M
No they will only send list of hldys and according to that I need to check from that list
M
Need use if condition s but iam not getting clarity how I can provide conditions
M
From where I need to start
JJ
so you already have a pre defined list of holidays for a particular year? this excel list already has days labelled(monday - friday)? or this will be part of the logic build?
R
Do it like this first assign your date to a variable
R
And then in a while loop use lookup datatable and after lookup datatable do this manipulation AddDays(-1)
VG
As per my understanding, he is having list of dates that need to be checked whether it falls under holiday or not
R
And put condition of while Loop
Index = -1
Index = -1
R
Where index is the output of your lookup datatable
R
Then when you exit the while loop you will have your required date
R
Day you want to extract
M
Yes I have hldy predefined list and no there is no labelled names there
VG
Means you want to find which day it is using that date value right?
If yes then you can use this
DateTime.Parse(ur date value as mm/dd/yyyy).ToString(“dddd”)
It will give you Sunday, Monday, Tues.... So on..
If yes then you can use this
DateTime.Parse(ur date value as mm/dd/yyyy).ToString(“dddd”)
It will give you Sunday, Monday, Tues.... So on..
VG
So you can loop through list of date here and get it's days then implement ur further logic
M
Not exactly