Weekly Calculation

[#1]

Hi All

I would like to create a list box that shows weekly ranges for the selected Month starting from monday to sunday in a calendar day number format e.g  "1-7 Week1", "8-14 Week2"...etc How can I do this?

[its_anandrjs · Accepted solution]

Hi,

Try to write expression in any list box like

=Day(WeekStart(DateField))&'-'&Day(WeekEnd(DateField))&' Week'&Week(DateField)

Or You can create any field in the load script

Load

Day(WeekStart(DateField))&'-'&Day(WeekEnd(DateField))&' Week'&Week(DateField) as WeekAndDayStend,

From Source;

Regards

Anand

[#3]

Hi

Thanks for your reply. I wrote the line of code as you suggested

Day(WeekStart("RE_DAY"))&'-'&Day(WeekEnd("RE_DAY"))&'Week'&Week as WeekAndDay

I get an error "Field not found - <Week>

SQL SELECT *

FROM SORCE"

[its_anandrjs]

For this write

Day(WeekStart("RE_DAY"))&'-'&Day(WeekEnd("RE_DAY"))&' Week '&Week("RE_DAY") as WeekAndDay

Regards

Anand

[#5]

Thanks! It works. Now what do I do if I want this in a chonological order? e.g week1- week52

[saurabh5]

can u post the code how u derived week...or the script, to know what is causing the error?

[its_anandrjs]

Then in the list box properties >> Sort >> Sort By >> Select State (Auto Ascending) and Select Load Order (Original)

[#8]

Hi Anand

Never mind...i managed to figure it out. thanks a lot again for your solution

@Saurabh I'm good now thanks