I am generating a form Number (Request ID) using the ID of the forms from sharepoint form Library. I would like to generate a number based on the year and a sequence number. (Form ID)
Function would look Concact(year(request date), max(@ID)) This works fine but I would like to reset the max(@ID) to '0' for year 2010. How would I do this?