Week object

[nareshthavidishetty]

Hi am having week object as below'

But i need to show week1,week2,week3,week4,week5 ,if i click on week1 it reflects the calender

[tamilarasu]

Go to listbox property and type expression as

='Week' & YourFieldName

[MayilVahanan]

HI

Try like this

In Script,

'week' & Week(DateFieldName) as Week

[nareshthavidishetty]

Thanks! The o/p is as below after using the logic suggested by you

But its not the requirement i have only five weeks as week1,week2,week3,week4,week5 suppose if the user make moth selection with in the month usere wants to know third week sales means week3 sales

[jagan · Accepted solution]

Hi,

Try like this

Data:

LOAD

*,

Month(Date) AS Month,

'Week' & Ceil(Day(Date)/7) AS WeekInMonth

From DataSource;

Hope this helps you.

Regards,

Jagan.

[MayilVahanan]

Hi

Are you looking something like this

'Week' & Ceil(Day(DateID) /7) AS Week

[nareshthavidishetty]

Hi Jagan,

After using the below logic,

'Week' & Ceil(Day(Date)/7) AS WeekInMonth

am getting result as

which is not correct if we check with January-16 calender ,week1 having only 1 & 2 but here it shows 1 to 7 .please help me to get this.

Thanks..