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
Forum Discussion
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#])
No problem,
Right(ToText(Year([my date field])),2)
& "-" &
ToText([Record ID#])