Re: Calculating weeks

2002-07-27 Thread b.ware
I use the Now() function, and I just set my format to "ww" without parenthesis and it gives me the current week number. --- Georg Richter <[EMAIL PROTECTED]> wrote: > On Monday, 15. July 2002 20:28, Paul W. Reilly > wrote: > > Hello Paul, > > maybe > http://www.mysql.com/doc/D/a/Date_and_time

Re: Calculating weeks

2002-07-15 Thread Georg Richter
On Monday, 15. July 2002 20:28, Paul W. Reilly wrote: Hello Paul, maybe http://www.mysql.com/doc/D/a/Date_and_time_functions.html could answer your question (Function week() ) Regards Georg > Trying to count weeks! I am doing a personal accounting system in > php/mysql. I have a report sect

Calculating weeks

2002-07-15 Thread Paul W. Reilly
Trying to count weeks! I am doing a personal accounting system in php/mysql. I have a report section that groups and calculates expenses into running totals, so that I can see total amount spent in each category. I would like to add a break down to this that will show me the average weekly amou