Hello, I have a use case where in I have exported calendar from outlook to excel, and I have to input the time into time tracking portal based on the codes I have. So here comes the problem, When it is a holiday for example memorial day I have to input only Holiday code and hours, but not the meetings scheduled on that holiday. I tried to do for if condition where the code is equal to holiday code but not it is not working. Following are the steps I did:
- Read excel file and save it to data table variable
- For each row in data table variable
- Save codes, duration, start date, end date, hours/day, Today’s date in variables
- If start and end dates are in past or future, then do nothing, else flow chart check if start and end dates are equal to today, codes not equal to holiday do the regular hours, false holiday code, But it is entering both holiday and regular meeting for a holiday.
Please, any expert help is appreciated. Thanks in advance.