Need to get "Monday" as the start day of week in a report definition
Hi,
I need to get 1st day of a week in a column in a report definition.
I have been trying to use "The Week of" function and it gets Sunday as the start day of the week.
I have tried changing the operator locale and calendar to different locales but still I'm getting the same results.
I found out that the function alias "pxWeek" is the function behind the report definition function and noticed that it uses below query to get the first day of the week
SUBSTR(REPLACE(VARCHAR(TIMESTAMP(SUBSTR({1}, 1, 8) ||'000000') - ( DAYOFWEEK(TIMESTAMP(SUBSTR({1}, 1, 8) ||'000000'))-1 ) DAYS),'-',''), 1, 8)
I believe the minus 1 is the culprit here, but when I do any sort of change e.g remove minus 1 or add a 1 to the question it results in a SQL exception.
Has anyone come across this and have a resolution on how to get Mondays as the start day of the weeks?
***Edited by Moderator Marije to add FDBK Idea tags***
Updated: 8 Jun 2022 9:14 EDT
Pegasystems Inc.
GB
@IshanT70 Week Function (All Date Rule Alias functions) is not locale specific function and we consider Sunday as the start of the week.
There is a support article here : First day of the week cannot be set as Monday.
FDBK-30774 exists to improve pxWeek function and make it a locale specific function so that it does not always considers "Sunday" as the first day of the week .
I tried to find other forum posts such as this one and this one and documentation to help you further.
Did you try the solution provided in Calendar Days?
Let me know if you still need help with this and I will try to find a UI SME to help you further.
TSPi
US
check day of the week function which returns the number 1,2,3,4 and so on till 7 where 1 -sunday 2, monday
in that function you can change the second parameter to 2 represent start day is monday.
see the attachment