Apache OpenOffice Community Forum

I would like to assign each weekly report a sequential number based on the week it is produced (which will be generated based on parameters of beginning and end of the week, as there may be slight variation based on holidays). Our fiscal year begins June 1st, so it makes sense for that to be report 01.

Is there anyway to reset the counter based on the date? I thought I could use some sort of WEEK function, but this doesn't seem available in Base.

Cheers

Just a simple approach might be: populate a table with from/to dates and the week number. Use in the query the current_date to find the correct report/week number.