sys date capture

Hi all

Could some one please let me know, how to capture system date with vb code and write into database.

Thanks and Regards
Ram :)

Try:

Dim CurrentDate

CurrentDate = Now


Create the table, recordset

With NewRecord
'NowDate is a field in the table
!NowDate = CurrentDate
End With

;)

If you don't want hours and minutes, use the DATE() function ;)

JeffB