<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc: calcuate weeknumber-year missing in 2021" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139421#c15">Comment # 15</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc: calcuate weeknumber-year missing in 2021" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139421">bug 139421</a> from <a class="email" href="mailto:ralacroix@hydro.mb.ca" title="Robert Lacroix <ralacroix@hydro.mb.ca>"> Robert Lacroix</a> <pre>I like the approach with greater flexibility, so not being stuck with the definition of WEEKNUM. But users would still have a problem deciding how to make the function result match the formatted string. To parry this issue, how about a new WEEKNUM-type function that matches a given formatting code (whatever that turns out to be). There are already 4 weeknum functions (WEEKNUM, ISOWEEKNUM, WEEKNUM_OOO, WEEKNUM_EXCEL2003) so there can't be an objection that there would be too many; none of them does what we want!</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>