Day of Week

[#1]

Hi,

I want to select in "multi box" on year and a week (example: 2011-01; 2011-04) and i see in "text box" the days of this week (example for 2011-01 -> 3, 4, 5, 6, 7, 8, 9).

I prefer not use script, only expression/function in "text box".

Any Ideas?

Regards,
Nuno Maximiano

[its_anandrjs]

Hi,

Use Weekdays( Date ) in text box and multibox use

Year( Date ) & ' - ' & Week( Date )

Let me know if not works

HTH

Regards

Anand

[#3]

Hi,

I can't alter the "multi box".

The "multi box" have the example values: (2011-1;2011-2;2011-10;2011-20).

I want sellected 2011-1 and populate 7 text-box with values: 3; 4; 5; 6; 7; 8; 9 ( the values of the week 1 in year 2011).

I can't use Weekdays(DATE) in text-box because i don't have the complete DATE, i don't have the day.

[its_anandrjs]

Hi,

Load your data some thing like this in resident table

load

*,

Year(Date)&'-'&Week(Date) as YearWeek,

Weekday(Date) as WeekDay

Resident Temp;

Regards

Anand

[its_anandrjs]

Hi,

See the sample file

Let me know if not works

HTH

Regards

Anand

[its_anandrjs]

Hi,

But how you find with this type of data because it is not in pure date format so how could you make the weeks please find attached sample i think it may help you.

And let me know

HTH

Rgds

Annad

[Anonymous]

You could use something like:

=Min(Day(Date))

&', '&

(Min(Day(Date))+1)

&', '&

(Min(Day(Date))+2)

&', '&

(Min(Day(Date))+3)

&', '&

(Min(Day(Date))+4)

&', '&

(Min(Day(Date))+5)

&', '&

(Min(Day(Date))+6)

&', '&

(Min(Day(Date))+7)

in your text.

But this is not complete. When you week is falling in 2 months, it goes wrong.

I am going to try some and get back at you later.

[Anonymous]

I think I found a way, try this:

=Day(Min(Date))

&', '&

(Day(Min(Date)+1))

&', '&

(Day(Min(Date)+2))

&', '&

(Day(Min(Date)+3))

&', '&

(Day(Min(Date)+4))

&', '&

(Day(Min(Date)+5))

&', '&

(Day(Min(Date)+6))

[#9]

Thanks Anand and Dennis for help.