Where do I get that Access "funky date/time"?
Posted on 2006-06-24
I'm creating a database for a surgeon to catalog the films he has made of cataract operations he has performed over the past 7 years.
For legal reasons, I need to define a primary key for each record that can't be recognized as part of the medical record (else some snotty malpractice lawyer could figure out which operation referred to his patient and use it against us).
I don't want to use AutoNumber. So, I've been thinking that I could generate a record number based on the exact time (to the hundredths of a second) when the record was entered into the database.
I seem to remember Access internally views date and time in some funky format that results from treating the specified date and time as fractions of 1, but I haven't been able to find a description of that phenomenon and I don't know how to get Access to cough up its funky time in its funky format. It's coughed it up by accident for me in the past but, naturally, I can't get it to do it on demand.
Any suggestions would be most appreciated.