MS InfoPath Question
I am trying to create a unique number counter ID that will reset on the new year. I have the number counter part down, but I have no idea how to make it reset when a new year begins.

Example: 2010-0057, 2010-0058, 2010-0059..... 2011-0001, 2011-0002 etc.

Instead it's just continuing the sequence. Any ideas on how to implement this? The preferred method is without the use of programming. On a side note, I am integrating this with a SharePoint site and I am actually getting my sequential number from SharePoint's ID field. I am using a MAX(ID) formula for my number sequence.

** First time using this site so I am sorry if this question doesn't belong here.
MS InfoPath Question
===

I am trying to create a unique number counter ID that will reset on the new year. I have the number counter part down, but I have no idea how to make it reset when a new year begins.

Example: 2010-0057, 2010-0058, 2010-0059..... 2011-0001, 2011-0002 etc.

Instead it's just continuing the sequence. Any ideas on how to implement this? The preferred method is without the use of programming. On a side note, I am integrating this with a SharePoint site and I am actually getting my sequential number from SharePoint's ID field. I am using a MAX(ID) formula for my number sequence.

** First time using this site so I am sorry if this question doesn't belong here.