At one of my clients I use JDate as the invoice# along with the client code. This way I can keep it as integer. And if you want to search invoice# by a date, you can prompt for the date, convert it to JDate, append the client code (I put the JDate first) and determine the invoice#
Karen > Hello Jan – > > What if you used jdate instead? Then you only have yyjjj. Also unless > your rec’v go beyond 9+ years you could just use the last digit of year. > However caution for this upcoming year. Perhaps invoice number first then > date id. > > > > Sincerely, > > Paul D > > > > >
