Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.
3 Added specific version of RDBMS
| link
2 edited tags
| link
1
source | link

calculate count by month and year

I am trying to calculate how many people are on a waiting list or still on the waiting list at the end of the month. Ex. If 5 people are waiting in Jan and then in Feb 3 people get added to the list and one person in Feb gets off the list then at the end of Feb my count should be 7. I do have people on the list for over 365 days. So I need month and year.

My dates are in mm/dd/yyy . variables are dtlist(date went on list), dtofflist (date they went off list).

Any help would be appreciated.