Calculating on date intervals
I have a task where I need to calculate
Length
Active
Start month
End month
I take my data from a table that contains periods like this:
Start date (startdt)
End date (enddt)
I need to know for a given month
The length of all current (up to the ...