I have a calendar object in my module which shows monday as first day of week.
What can i do to change first day of week in the calendar to Sunday?
Date Format is DD/MM/YYYY.
i know the QV assumes first day of week to be monday, and if i want to have a FirstDayOfWeek field i use WeekStart(Date,0,-1),
But what i want to do now is to use Date field in a calendar object and have it start on sunday.
So i still have no idea how to achieve it.
What i would do is to go to script editor (ctrl+E)
Change the default setting from
Let me know if it worked
Already tried it, bur it seems that this setting is anly naming convention, and does not affect real week-day settings.
But thank you too for trying to help.
In that case try this approach.
Right click the chart and
chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type
Click ok & ok
Let me know if it work
That's a nice approach and it would surely work in a table. but my object is a calendar object, and i see no change in sorting.
Try this in the script editor
load dual ( string,numrep ) as DayOfWeek inline