First day of the Week

[Former Member]

Post Author: TomVDW

CA Forum: WebIntelligence Reporting

Hi, I have a little problem, when I make a report with the WebIntelligence, the first day of the week is on Monday. However, if I make the same report with the DesktopIntelligence, the first day of the week is Sunday. Even if I upload this report to the Repository and then open it with a web-client, it stays the same.Is there a way to modify the settings so the first day of the week is always Monday? The database I use is Oracle 8.1.7 Thanks in advance, Tom

[Former Member]

Post Author: jsanzone

CA Forum: WebIntelligence Reporting

Tom,

There is a function "DayNumberOfWeek" in WebI that uses the formula 1 thru 7, so perhaps you can write an "if" to go against this to roll back a day?