Creating a unique identifier
I am trying to create a unique identifier for my records that is
Last Two digits of the year - Record ID
I can't seem to get it right
Last Two digits of the year - Record ID
I can't seem to get it right
Forum Discussion
1 Reply
- Ah, refreshing to see a regular post not related to the UI change.
No problem,
Right(ToText(Year([my date field])),2)
& "-" &
ToText([Record ID#])
