Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
...
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