Working on an absence database. Start Date and End dates are recorded. From this I then calculate the number of days absent. However when reporting I need to display absent days per month.
So if Joe is off from 27/07/12 thru to 04/08/12 I need it to show x days in July and y days in August.
Any help would be gratefully received.
Fozi
So if Joe is off from 27/07/12 thru to 04/08/12 I need it to show x days in July and y days in August.
Any help would be gratefully received.
Fozi