On Sun, 2019-08-25 at 15:34 +0200, Robert Großkopf wrote:
Hi Harvey,I am using Mariadb10 as backend from a Base client via JDBC. I have created the function within a Base Query (GUI).So it isn't a LO-problem. WEEK gives (in MariaDB/MySQL) 0 - 53, if you start the week with Sunday. WEEK('2019-01-01',1) gives 1, because it returns values from 1 - 53. See https://mariadb.com/kb/en/library/week/ for the right mode. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3
Terrific, Robert! That is what I needed to know! Many thanks. Harvey -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy