Week Range

[Former Member]

Hi Experts,

I need show week range based on date parameter.

I have a date parameter in my report (dd/mm/yyyy).

If i select date=05/01/2013 i need to show week range as 1-2.Any suggestions greatly appreciated.

Thanks in advance

Francis

[former_member203168 · Accepted solution]

Hi ,

Use the below formula to find the Week number of your date field

DATEPART("ww", {?Date_Parameter}, crSunday)

--Praveen G

[Former Member · Accepted solution]

Hi Guntuka,

I want to show week range not week number

[abhilash_kumar · Accepted solution]

Hey Francis,

Maybe you can use this code:

DATEPART("ww", {?Date_Parameter}, crSunday) &" - "& DATEPART("ww", {?Date_Parameter}, crSunday)+1

-Abhilash

[former_member203168 · Accepted solution]

Hi Francis,

Use the below formula to achieve your requirement.

numbervar x:= DATEPART("ww", {?My Parameter}, crSunday);

"week range as" + totext(x,0)+ "-" +totext(x+1,0)

--Praveen G

[Former Member · Accepted solution]

Hi thank you Abhilash and Guntuka both of your formulas are working.