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

 Ashwini Pathak (AshwiniP6144)
Bank of America
Vice President Cnslt Apps Prog
Bank of America
US
AshwiniP6144 Member since 2016 2 posts
Bank of America
Posted: Apr 11, 2018
Last activity: Apr 12, 2018
Posted: 11 Apr 2018 23:39 EDT
Last activity: 12 Apr 2018 16:51 EDT
Closed

How to write function in report definition to pull cases from Friday to Sunday on Monday?

When user pull the report everyday, report pull cases from previous day. So I coded in filter, pxCreatDate is equal to Previousday. But on Monday, I want report to pull cases from Sunday, Saturday and Friday. How to do it?

To see attachments, please log in.
Reporting

Posted: 6 years ago
Posted: 12 Apr 2018 16:51 EDT
Ron Lee (RonLee_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

Given the standard SQL date functions available, it seems like it would not be difficult to check if the current day is a Monday using DAYOFWEEK(CURDATE())=2, and if it is, use DATE_SUB() to subtract 2 extra days from the previous day  you are already calculating in your "Previousday" function alias.

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