Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use Weekdays( Date ) in text box and multibox use
Year( Date ) & ' - ' & Week( Date )
Let me know if not works
HTH
Regards
Anand
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.
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
Hi,
See the sample file
Let me know if not works
HTH
Regards
Anand
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
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.
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))
Thanks Anand and Dennis for help.