Discussions

Expand all | Collapse all

Creating a unique identifier

  • 1.  Creating a unique identifier

    Posted 01-22-2018 20:05
    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


  • 2.  RE: Creating a unique identifier

    Posted 01-22-2018 20:13
    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#])