Date Problem

[ajsjoshua]

Hi all,

I have two calendars Week_UP and Week.

If the user clicks Week_UP=1 then it should show week=1 to week=12.

some what i achieved it but i am facing some difficulties  kindly see the attachment.

i am using this expression in list box

=Aggr( Only({<Week = {">=$(=Max(Week_UP)) <=$(=Max(Week_Up)+11)"},Year={$(=Max(Year_UP))} >}WeekOfYear),Week,Year )

[ajsjoshua]

Hi,

can i use week serial for this.

[ajsjoshua]

Hi all,

suggest me some ideas

[Anonymous]

hI,

=Aggr( Only({<Week = {">=$(=Max(Week_UP)) <=$(=Max(Week_Up)+11)"},Year={$(=Max(Year_UP))} >}WeekOfYear),Week,Year )

in your project  Max(Year_UP)  will give 2015.

try to remove it or please think of it ???