AnsweredAssumed Answered

Unique Client ID, how to calculate with new year

Question asked by jimmelo on Jul 5, 2011
Latest reply on Jul 7, 2011 by rjlevesque

Title

Unique Client ID, how to calculate with new year

Post

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.

Jim

Outcomes