Question How to format based on week number?

[shieriel]

I have a database with an average monthly performance summary. How can i format to show the summary per week in a month? For example in January, instead of showing the January average from January 1~31, how can i format to show the average per week, say Jan1~7;Jan8~14;etc.
Please help me...

 

[DCrake]

Use format(YourDate,"ww")

 

[gemma-the-husky]

note that there a number of options in the format command to determine exactly how a date corresponds to week 1 (and which corresponds to week 52 or 53 from the previous year.)

 

[shieriel]

note that there a number of options in the format command to determine exactly how a date corresponds to week 1 (and which corresponds to week 52 or 53 from the previous year.)

Can you give me some sample database please?

 

[gemma-the-husky]

it explains in help

 

[shieriel]

Use format(YourDate,"ww")

It works perfectly! Thank you very much....