My company uses an alpha-numeric substitution function. For example, say 1=A, 2=B, 3=C ... 8=H, 9=I and 0=J. They then convert a date in international format (DDMMYY) using the substitution so that a date of "311218" (Dec. 31, 2018) would convert to CAABAH.
In a traditional programming environment, I would use a FOR loop and loop through the 6 digits of the numeric date to compare each digit against a CASE statement or something similar. With each loop, I would add the character substitution to a variable and build out the new value until I got all 6 letters.
Not sure how to accomplish this with PowerApps though. Any ideas would be greatly welcome...
@Mike2500 - you have been a wealth of great ideas. Any thoughts?