Reading an excel file cells and performing logic based on data inside cell
Hi, I ahve a task where i need to read an excel file and one of the column is date column where based on value in those cells i have to calculate number of hours using sysdate. So how to do that using PEGA RPA.
Please note that i am very new to RPA so need the details with explanation(if its possible)
I am not sure what you mean by sysdate and calculating a number of hours. I created a sample solution that calculates the number of hours between the date value in the spreadsheet to "Today". You should be able to modify this as needed for what you are doing.