Forum Discussion
Count days separated by month
Hi Say I have table with 2 dates (field1 & field2) 20/12/2020 & 10/01/2021 How would I show the datediff by month in a query e.g. Dec 20 = 12 Jan 21 = 10 Or if the dates were 28/08/2021 ...
Sometimes it can help to explain the real world problem you need to solve, rather than trying to "simplify" by abstracting out just a few details.
Like Colin, I can't see any logic in the examples provided as raw numbers.
What is the goal? Why are you counting months, or is it days?
Thanks for providing enough context to help us offer suggestions.