Skip to main content
Contact a Moderator

Question

1
Replies
109
Views
 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: April 3, 2019
Last activity: April 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

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 3 Apr 2019 18:14 EDT
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US

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