ContributionsMost RecentMost LikesSolutionsFormula for # of years since inceptionI am trying to get #of years & months since inception from today's date. //ToDays([Inception Date]- Today()) / 365.25 I end up with a -negative #. ------------------------------ [Deb] ------------------------------ Re: how to automate assigning case numbers with each new record starting with 19001Thanks Dan...this is perfect!Re: how to automate assigning case numbers with each new record starting with 19001Great. This is what I needed. how to automate assigning case numbers with each new record starting with 19001When creating a new record, I would like QB to automatically assign the next sequential number. There are several users and each lab/webinar we do, must be assigned a C-XXXXX number. Currently we access an excel spreadsheet visible to all so we now what number is up next. I need to start the new year with C-19001....... How do I go about automating sequential numbering.