change first day of week in a calendar object

[datamind]

Hi,

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?

Thanks,

Raz/

[raz-datamind]

Hi Gabriel,

I'm sorry, but I still can't see where are you going with this.

I have a [Sales Date] field in a calendar object, how am i going to use the DayOfWeek field in order to sort that Calendar?

my script is as follows:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';

LOAD date as [Sales Date]

FROM <csv file>

Thanks,

[Gabriel]

Hi,

Try this

In the calendar object right click > Properties > Select the drop down for Field > <Expression> and enter =WeekDay([Sales Date])

Click OK & OK

This should change weekday in the calendar according to your settings

Regards

[raz-datamind]

Hi,

No, I'm sorry, but it returns an error: calendar is showing Dec 1899.

Attached is a qvw with a try of what you suggested.

Thank you very much for helping out.

[#5]

Hi Haim, did you ever find a solution to this?  I am trying to achieve the same thing; you would think it would be a simple setting on the object, but I cant find anything.

[Karim_Khan]

It will create problem if u go for long term calendar and mentioning the day number