Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Pratik Parag (PratikP1464) Blue Cross and Blue Shield of North Carolina
Blue Cross and Blue Shield of North Carolina
IN
PratikP1464 Member since 2018 5 posts
Blue Cross and Blue Shield of North Carolina
Posted: Apr 3, 2019
Last activity: Apr 3, 2019
Posted: 3 Apr 2019 7:18 EDT
Last activity: 3 Apr 2019 18:14 EDT
Closed

Reading an excel file cells and performing logic based on data inside cell

Report

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)

Robotic Process Automation
Posted: 4 years ago
Posted: 3 Apr 2019 18:14 EDT
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US
Report

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.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice