create a unique id with year, month, day, hh,mm,ss

[sal21]

when i click on command button, i need to crete a unique IDNAME...

For example, based time value:

IDNAME="09082021135228"

currdatehhmmss

Peraphs is one of my first question, about 15 year old

[HansV]

That would be

Code: Select all

    IDNAME = Format(Now, "mmddyyyyhhnnss")

but I would prefer

Code: Select all

    IDNAME = Format(Now, "yyyymmddhhnnss")

because that would make it easy to sort the IDNAME values.

[sal21]

That would be

Code: Select all

    IDNAME = Format(Now, "mmddyyyyhhnnss")

but I would prefer

Code: Select all

    IDNAME = Format(Now, "yyyymmddhhnnss")

because that would make it easy to sort the IDNAME values.

TKS!
I choose the second, because is a good tips!

[SpeakEasy]

Of course, you need to make sure that at least 1 second has elapsed between ID assignments ...