Hello. Hi!
The problem is simple, but the answer doesn't seem so...
I'm trying to count the number of days per month per year between two dates.
So for the following 2 dates:
2013.12.15
2014.02.18
I would have something like:
Year | Month | Days
2013 12 16
2014 01 31
2014 02 18
So, with 2 dates, i would get as many rows as months between then.
I would like to achieve this using only a Select statement, but am completelu lost.
Anyone one out there can crack this? 😀
Bookmarks