InfoPath Dev

I have a repeating table that I am trying to represent as a billing schedule and outside the table I want to have the sum of the schedule with the trigger being that current date equals Month/Year. 

Month/Year           Amount         Month/Year        Amount          Month/Year        Amount

 Any help will be much apprecated.

John

 

Are the month/year values in MM/yy, MM/yyyy, M/yy, yyyy-MM, or some other format?  Are they in a uniform format?

I have made the change this morning to MM/Day/Year since a change could happen on any given day of the month. And yes as of this morning they are in uniform format via date picker.