• Susan Shopaugh
  • 0 Points
  • Member since 2012

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0

We have our quote numbers set up as custom auto generated numbers, so that it shows the year, month and then the sequence number. Q- {YYYY}{MM}{000}. How can we make it reset to zero when the month changes? We the quote numbers are getting far too long.


What we need is for the following or trailing three numbers to be dependent on the month, so when it changes the following 3 digits reset. Is there a formula or rule we can make so that our numbers don't get too long?