Can I determine on what day I added data to a table?

C

Ciene

I need to make an accounting for my company and need to know on what dates I
entered data into certain tables? Is it possible to go back and find this
information in the database?
 
R

Rick B

Nope. You can add timestamps and begin tracking this from this point
forward, but if you were not tracking it in the past, you are out of luck.
 
A

aaron.kempf

he doesnt mean TIMESTAMPS

he means a Date/Time field; and you can either default this to NOW() or
GETDATE() depending on if you're doing this in MDB (via VBs' NOW()
function) or SQL Servers now function = Getdate()

TimeStamps won't really tell you date information; right?

-aaron
 
Top