Discussion
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
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,
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
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.