I have an ticket tracking system in a SharePoint list that runs by a Fiscal year, month, then counts for the month. And my leadership wants to automate the number assignment.
Ex: ABC (current calendar year) - 01 (Jan) - 0001 (incident #) will read fully as ABC-01-0001. I've got the ABC and Month figured out. I have a 2010 workflow set up to assign those numbers upon creation. I'm stuck on resetting the incident number (0001) at the beginning of each month. For Feb it would be ABC-02-0001.
Any suggestions would be greatly appreciated.
Thanks