Unique ID based upon date
Hi there - I am a FM novice, but am learning and love the interface and will likely use it a lot for my current and future work.
I am stuck in trying to create a unique ID based upon today's date. For example, I want the unique id to be DDMMYYXX - so today, the first entry would be 25111301 and the second would be 25111302, etc etc. I thought I would use the "serial number" feature, but can't figure out how to get this done and thought the experience here would be able to help me easily. Thanks for the advice and I apologize for my naiveté !