I want to group within a group by date difference. For example, if there are 7 cases in facility A, but the first 5 cases happened before 14 days of the last 2 cases, I want them to be in two differen...

Trying to calculate a date difference beteween two occurrences in cases (date1 minus date2 minus 1), but get the following error: SELECT Failed. 3707: Syntax error, expected something like an 'END' ke...

I am tracking payments made on a large excel file. In column C, I have the date we received the payment, in column I, I have the date paid. I'd like to calculate how many months between column C (when...

I'm trying to figure this out, but it's driving me insane! How do I calculate in SQL the number of days that are in a specific year between two dates? For example: we have the range date [12/30/2016-...