automatic date formatting?
 

hi all, right now I am trying to set up a spending record in OO for personal use. I'd like to get both weekly and monthly summaries of spending using a 'cost' column with 'total' summary type but it seems I can't do both at the same time given the linear nature of OO. In other words, if I set up Month "May", "June", "July" menus then I can get a monthly but not weekly spending summaries (given that making weekly submenus splits weeks between months) and if I choose to go by the week then months are equally hard to do.

Anyone know how I might solve this?

Thanks,
Tim