how to calculate the week?

[gkcchowdary]

Hi,

I have date filed and i am writing week(mydatefield).so i am getting the complete weeks entire year.

1233456789.....

my requirement is when i select feb i want show only fed weeks like1,2,3,4 weeks .

if i select jun again show only jun weeks starting 1,2,3, 4 like that.how to achieve this.

Thanks

chaitu

[swuehl]

In your master calendar, you can create the month based week counter like

LOAD

     Date,

     Week(Date) as Week,

     Autonumber( Week(Date), MonthName(Date) ) as WeekInMonth,

     Month(Date) as Month,

     MonthName(Date) as MonthName,

     ...

[uacg0009]

Hi krishna,

I have a question, if you select feb and jun at the same time, then what do you want to show?

Thanks.

Aiolos