Discussion

3
Replies
639
Views
 Yavuz Uydu (YavuzU07)
ANZ

ANZ
AU
YavuzU07 Member since 2015 1 post
ANZ
Posted: July 28, 2015
Last activity: August 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

Reporting
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 Discussion, please write a new Discussion.
Posted: 5 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. 
Posted: 5 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