I am working on a split database in Libre Office Base Version: 220.127.116.11, on Linux Mint Sylvia.
I have a calendar in which I need the week numbers in the year and the day numbers.
UPDATE “NEWYEAR” SET “DAYNUM”= DAYOFWEEK (“Date”)
UPDATE “NEWYEAR” SET “Week” = WEEK (“Date”)
Now when I request the daynumbers (the number 1 is Sunday as the first day of the week. But when I request the week number as above, Sunday is the last day in the week.
How do I get these numbers to concur. I would prefer to have Sunday as the first day of the week in both cases if that is possible.