I'd like to have a unique record ID that includes elements of dates and record ID. The dates should help identify loans visually.
Desired output:(YY)(MM)(6 digit unique #)
Example: 1601001000 (from Jan 2016 + 6 digit number)
*Month needs to be 2 digits (01 rather than 1)
*Digits following YYMM to be 6
Used this formula but it does not maintain the number of digit format desired:
Right(ToText(Year(Today())), 2) & " - " & Right(ToText(Month(Today())), 2) & (1001 + [Record ID#])
Desired: 1604002433 (16)(04)(002433)
Any help would be greatly appreciated!