calculed field to have week number 1

[angel75]

Hi,

First, Sorry for my english......
I need to have a calculed field in a table which represents the week number of a date field in it.

 

[jimfrith]

This might give you a start. I didn't test it and my guess is that you may have to add 1 to the final result. to get the week number to start at 1 instead of 0.

Trunc ((Reporting_Date -ToDate("1/1/"+ToChar ( ToYear (Reporting_Date ),0)))/7,0)