Week Number Count

[Anil_Babu_Samineni]

Hello Friends,

I do have one Date Field. In that, i want to show the week number in Text object.

I written, Count(Week(DateField))

Is that expression is correct?

[MindaugasBacius]

Simple use week(DateField).

To get the week number in the TextObject you need to select only single Date.

[MindaugasBacius]

Also suggest you reading this blog post:

Redefining the Week Numbers

[Anil_Babu_Samineni]

Thanks Sir,

If i have 2005 to 2016 and then it showing 12 * 52 == Value

If i am using this it will working

=Count(distinct week(DateField))

Thanks

[MindaugasBacius]

In this case you need the total number of weeks between two dates, am I correct?

[MindaugasBacius]

 = (max(DateField) - min(DateField)) / 7

This formula allows you to get the exact number of weeks between two dates.

[Anil_Babu_Samineni]

Ok, This scenario i have only one Date field. How to get that. Is my expression is correct?

[MindaugasBacius]

Use this one:

= (max(DateField) - min(DateField)) / 7  

Instead of DateField use your Date field.

[Anil_Babu_Samineni]

So, i want to show the weeks which is

If i want to show the report that time i want to show upto last week with the key of Starting Date to Reporting date - 1

Something like that. This scenario how do we use that

[dineshraj]

Hi Mindaugas Bacius,

I need make 19/4/2007 this week as first week of the year.

How to get it?