i want a field to display the first 3letters of the current month then a sequential number ( digits)e.g APR001
how do i go about this. sorry i’m a newbie!
Subject: date question
The three-letter thing is easy:
@Select(@Month(); “JAN”; “FEB”; “MAR”; “APR”; “MAY”; JUN"; “JUL”; “AUG”; “SEP”; “OCT”; “NOV”; “DEC”)
It’s the sequential number thing that’ll keep you up nights. Frankly, there’s no good way* to do sequential numbering in Notes**. Search the R4 7 R5 forum for “Sequential number” for a number of limited methods.
- By “good way”, I mean a method that prevents both “holes” and duplicates, and that works across multiple replicas.
** Availing yourself of a relational database’s auto-increment facility through ODBC calls will do the trick, but that’s not “in Notes”.