The Dutchman
Board Regular
- Joined
- Apr 10, 2008
- Messages
- 72
I have created a field to keep track of every date/time a record was posted. I have created a variable sysdate and made that = Date.
When I saved
When i check the actual cell, the date is correct but the time is always 12:00:00.
Does someone know how to rectify this?
Thx
When I saved
Code:
Dim sysdate as variant
'when I copy the records over, the code for sysdate is...
Cells(nextrow,3) = format(sysdate, "mmm-dd-yy hh:mm:ss am/pm")
When i check the actual cell, the date is correct but the time is always 12:00:00.
Does someone know how to rectify this?
Thx