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 :)
Printable View
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