Convert Current Date and time to serial (1 Viewer)

[zezo2021]

I have an idea to general unique number

I want to convert the current date and time to serial


How can I do that

is a good idea to generate a unique number


please provide the code thanks for the help

 

[theDBguy]

Hi. Sorry for my confusion, but what do you mean by "serial?"

 

[arnelgp]

use CDbl([dateField or dateVariable])

 

[Gasman]

is a good idea to generate a unique number

That is what autonumbers are for?

 

[Minty]

Or use a GUID data type?

Forget that it's Excel.

 

[Gasman]

Or use a GUID data type?

Forget that it's Excel.

Oops, missed that
O/P was also advised of Row() ?

 

[The_Doc_Man]

I have an idea to general unique number

I want to convert the current date and time to serial


How can I do that

is a good idea to generate a unique number


please provide the code thanks for the help

Unfortunately, this is not a good idea. The problem is made worse by the fact that most of the Office date/time conversion routines are NOT guaranteed to yield unique numbers based on the NOW() function as a way to get a timestamp.

I know from other posts that you are trying to use an Excel-based app as a database with hidden tables. The biggest "gotcha" in this "use date/time" idea is that if you have tables sitting in the background and have multiple users pounding away on their keyboards in the foreground with their own copies of your front-end app, it is NOT out of the bounds of probability that two people could hit the ENTER key (or whatever you are using) at the same exact time. This would then translate to the same exact number as the output of the conversion. Office does not normally work in fractions of a second even though a Date variable could in theory hold milliseconds for dates. Further, you have limited resolution for the fastest "easy" timer that DOES hold fractional seconds. Even trying to use the Timer() function, that only is good to 1/60th of a second, so all you would be doing is "playing the odds" on the number you get.

It is up to you, of course, but if you are asking if this will work, I would have to say "Unlikely."