Show the selected week in the Label.

[#1]

Hi! is there a way to show the selected week in the Label field? (in a column)

//BR
Patrik

Edit:

Hi! thoose work but i was a little unclear in the first post sorry.

The thing is that I've six column displaying:

If i choose an interval where first week is week six and last week is week twelve

1st column: first week in the selection

2nd column: second week in the selection

3rd column: third week in the selection

etc etc

I would like the 1st column showing the first week name in the selection and the second week showing the second weeks name, etc

is it possible to do?

//BR
Patrik

[jagan]

Hi,

Use this expression in Label

=Only(Week)

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     use Label as =GetFieldSelections(WeekFieldName,',') shows if selected many separated with comma.

     Or you can try with this

     =if(GetSelectedCount(WeekFieldName)>0,GetFieldSelections(WeekFieldName,','),'Week')

Hope it helps

Celambarasan

[Anonymous]

hi

Hope this attached file expression (textbox) will help you to show the selected date week name in the column or lable

Regards

Ashok

[#5]

Hi! thoose work but i was a little unclear in the first post sorry.

The thing is that I've six column displaying:

If i choose an interval where first week is week six and last week is week twelve

1st column: first week in the selection

2nd column: second week in the selection

3rd column: third week in the selection

etc etc

I would like the 1st column showing the first week name in the selection and the second week showing the second weeks name, etc

is it possible to do?

//BR
Patrik

[CELAMBARASAN · Accepted solution]

Hi,

     Then try by incrementing

     Min(Week),Min(Week)+1,Min(Week)+2..Min(Week)+6

Celambarasan

[jagan]

Hi,

Use this expressions

1st Week = Min(Week)

2nd Week = Min(Week) + 1

3rd Week = Min(Week) + 2

4th Week = Min(Week) + 3

5th Week = Min(Week) + 4

6th Week = Min(Week) + 5

Regards,

Jagan.