Hello,

Does GridView have a function the get the week number of the date? Or is there a formula that I can use to get the week number of a date?

Marlon

Hi Marlon,

The next Upgrade to GridView will have this function, but how do you define you weeks? Do they start on a Sunday or a Monday? Is Jan 1-7 week #1, regardless of the day of the week? (in which case you can use:for the simple case.

Hello Andrew,

Thanks for the information. We used Sunday as the start day of the week.

Marlon

So, if January 1 is a Wednesday, then Week #1 goes from Jan 1 to Jan 4? Or does it go from December 29 to January 4?

On your example, Week #1 go from December 29 to January 4.

Marlon

You may have to wait for the Upgrade to calculate this properly.

Thanks! I'll work with your formula and see what else I can do with it.

Marlon