Hi Everyone,
I have two tables A and B each of which containing dates. The Table A has dates for the year 2013 and 2014 and whether a day is billing day or not in that year ( represented as 0 or 1) as Billing Day field. The table B has Country names and other data. Table C has dates for the year2013, 2014 and 2015 and other data. I have taken two list boxes, one for Month and one for Day as inputs.
The list boxes are from table B and when the month and day from the list boxes are selected,
1. the total no. of billing days year wise
2. the no. of billing days from start of each year to the selected date in those years has to be displayed.
The output required is something like this:
Date Selected: Feb 2
Country Year Total Billing Days Bill Days till date
USA 2013 253 23
USA 2014 253 22
USA 2015 - -
Canada 2013 252 23
Canada 2014 252 22
Canada 2015 - -
PR 2013 - -
PR 2014 - -
PR 2015 - -
CR 2013 - -
CR 2014 - -
CR 2015 - -
Message was edited by: uday p
