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

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)

To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 3 Apr 2019 18:14 EDT
Thomas Sasnett (ThomasSasnett)
MOD
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.

To see attachments, please log in.

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