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.

Discussion

 Yavuz Uydu (YavuzU07)
ANZ

ANZ
AU
YavuzU07 Member since 2015 1 post
ANZ
Posted: Jul 28, 2015
Last activity: Aug 21, 2015
Posted: 28 Jul 2015 0:34 EDT
Last activity: 21 Aug 2015 3:31 EDT
Closed

Calendar Days

Hi all,

 

I am having difficulties when using a filter on a report for a Calendar week. Reports are generating the calendar week from Saturday 'til Friday. I need this changed to Monday to Sunday. If anyone has any idea any help will be greatly appreciated.

 

Thanks,

Yavuz

To see attachments, please log in.
Reporting

Posted: 9 years ago
Posted: 13 Aug 2015 3:36 EDT
Srikanth Challapilla (Srikanth)
PEGA
Senior Manager, Security Engineering
Pegasystems
IN

are you using pxDayOfWeek function? this function accepts the start of week as a parameter , if unspecified it defaults to sunday. How are you getting saturday as first day of week?

 

Please provide more information so that we can help. 

To see attachments, please log in.
Posted: 9 years ago
Posted: 21 Aug 2015 3:11 EDT
Yavuz Uydu (YavuzU07)
ANZ

ANZ
AU

Hi,

We are using Day of [Resolution] and when we place in the filter,

then we use Calendar Week - Previous Week, it starts the week on a Saturday!

Please help.

Thanks,

To see attachments, please log in.
Posted: 9 years ago
Posted: 21 Aug 2015 3:31 EDT
Srikanth Challapilla (Srikanth)
PEGA
Senior Manager, Security Engineering
Pegasystems
IN

pyPreparedValues(2)
20150809T040000.000 GMT
pyPreparedValues(3)
20150816T035959.999 GMT

 

I ran the report just now and see the range is set correctly. It starts on 9th Aug beginning and ends at 16th Aug end of day. 

The range is always in GMT. If your DB is ahead of GMT or behind, you may have a spillover of values. But if your Database locale is correctly set to GMT, no such issue will be seen

To see attachments, please log in.

Related content:

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