List Box - Week with Start Date and End Date

[bhuprakash]

Hi All,

I want to show the week with their start date and end date in the list box.

Can you please help me to get this done. Below is the format in which i want to show the data.

[Anil_Babu_Samineni]

May be use WeekStart() and WeekEnd() functions ??

[martinpohl · Accepted solution]

edit your script:

Week(DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) as ACTIVITYWEEK

to

Week(DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) &': '&weekstart (DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) & ' to '& Weekend(DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) as ACTIVITYWEEK,

regards

[zhadrakas]

Expression for list box:

='Week' & ACTIVITYWEEK & ': ' & MakeWeekDate(year(today()),ACTIVITYWEEK) & ' to ' & WeekEnd(MakeWeekDate(year(today()),ACTIVITYWEEK))

you should create a yearWeek Field to get the change over years correctly.

[bhuprakash]

Hi Martin,

This is showing exactly i want but if I click on Oct month then it is not selecting all the weeks falls in Oct month.

So this causes of showing incorrect data.

[bhuprakash]

when i am selecting Oct month then it is not selecting Weeks falls under Oct month.

Please see the attached file.

[bhuprakash]

Sorry.. Checked again.. It is working fine.

Thanks a lot everyone.