Beatrix
05-03-2016, 11:33 PM
Hi All
I have got a table in Access which has open and closed date information. I need to calculate the number of months between 2 dates and break into the quarters. I started doing something very simple in access sql but I don't think it's going to work and need to find a smart way to get this done. Any suggestions?
I attached a sample file with before/after scenario.
Your help would be much appreciated.
Best.
B.
I have got a table in Access which has open and closed date information. I need to calculate the number of months between 2 dates and break into the quarters. I started doing something very simple in access sql but I don't think it's going to work and need to find a smart way to get this done. Any suggestions?
I attached a sample file with before/after scenario.
Your help would be much appreciated.
Best.
B.