Bot will run Saturday sunday and all Indian holidays
Yes, sat n Sunday we can run from orchestrator but in all Indian holidays how will it works
Create a calendar and mark all the sundays,saturdays and indian holidays as working days and choose the calendar
That way the bot would run on only those days as per the choosen calendar
Yes i have sheet of sat, Sunday and holidays so how to code will develop
Please take a look at this, where you can upload the calender & define the non-working days:
The same defined calendar can be configured while creating a trigger.
If you want to run the process on non-working days (holidays & weekends), then you can define all the working days in the CSV file that you are going to upload in the ‘Non-Working Days’ tab.
Hope this helps,
Go to irchestrator and create non working day calander by uploding that sheet
Run the bot daily…and then in your bot first check if todays date is present on your excel will the required dates.if yes proceed further else end the bot for the day
How should I code develop
Is the format is wright to understand the bot today’s date and excel date is match so bit can move forward
Can you Please print & share what data does “DT” contains
DT is null showing how?
Did u complete running Read Raange Activity?
May be you should do one more “Step Into”
@Jithesh_R i have complete the read range activity and output is coming like this
Put this inside If condition and check
DateTime.ParseExact(CurrentRow("Date").ToString, "MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy").Equals(Now.ToString("dd/MM/yyyy"))
Okay let me try ,
This error occurred