Unique Client ID, how to calculate with new year
Ok I realize the title isn't the best but here is what I am trying to do. I wan to create an internal unique ID that I can use to sort clients from 2011, 2012, 2013, etc. So I want this unique ID to b:
Year ( Get (CurrentDate ) ) & "Firm" & [+ 1 for each new client]
in other words the first client will have the unique ID number 2011Firm001
the second will be 2011Firm002, etc.
In 2012 I want it to start again at 2012Firm001, etc.
I also am using a unique client ID number that is just a straight up count from 1 but I have reasons for doing it this way (promotions, etc.).
Any help would be greatly appreciated.