Week Count Formula

[hgraybill]

I need to create a formula that will count the week numbers from the current date, but I'm stumped.

I've tried the datepart() formula, but haven't come up with anything.

Here's an example of what I'm after. If I was to run the report today, I would need each week numbered. For example this week would be week 1, next week would be week 2, etc.

Any help is greatly appreciated.

 

[lbass]

If today were selected (Tuesday), would the week be Sunday, February 1 to Saturday, February 7? If so, you could use:

//{@Week#}:
if datepart("ww",{table.date}) = datepart("ww",currentdate) then
"Week1" else
if datepart("ww",{table.date}) = datepart("ww",currentdate)+1 then
"Week2" else
if datepart("ww",{table.date}) = datepart("ww",currentdate)+2 then
"Week3" else//etc.

-LB

 

[hgraybill]

Yes, that's exactly what I needed.

Thank you for the help!