VBA Format Date mmm-dd-yy hh:mm:ss am/pm

[The Dutchman]

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

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

 

[The Dutchman]

I forgot the following code after the Dim statement

sysdate = date

 

[lenze]

hi and welcome to the board!!!

Use

sysdate = Now

lenze

 

[The Dutchman]

In hindsight it's so bloody obvious!!!!

Thx for your speedy response,

Ray