So here is my situation. I need to collect data from a spreadsheet. This spreadsheet of data has basically 2 columns that I am interested in. One column has the work day number (1-28) and the second column has the relevant value for that day.
For other parts of the operation the robot already knows the relevant work days (example. first complete week of february would be between 2/4 and 2/8) The robot already knows this range and actually that range is decided by the processor ahead of time. Since february has that first day on friday, the processor may choose 2/1 - 2/8 and the robot will know this is the “first week”.
Now I have an activity to basically break down the date value and just pull out the day value, i.e. 01 and 08. Now I want to run a for each on the datatable from the data spreadsheet and basically I want it under the condition if row.item(0) >= startofweekday AND row.item(0) <= endofweekday then get row item of the value (row.item(1)), write into cell. I have all of the if statement done, i think. but I cannot get past this initial condition. Since it was originally a date I tried changing the format of the startofweekday and endofweekday to strings, doesn’t work. I tried converting to int32 but i run into an error doing that.
This was just my idea on how to solve this problem. if there is an easier way to compare these two numbers than someone please help!