CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. November 3rd, 2002, 09:05 PM #1
    Ram15
    Ram15 is offline Junior Member
    Join Date
    Oct 2002
    Location
    Australia
    Posts
    6

    Question 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
    Reply With Quote Reply With Quote
  2. November 4th, 2002, 12:28 AM #2
    ilin
    ilin is offline Junior Member
    Join Date
    Jul 2001
    Posts
    23

    Wink

    Try:

    Dim CurrentDate

    CurrentDate = Now


    Create the table, recordset

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

    Reply With Quote Reply With Quote
  3. November 4th, 2002, 09:56 AM #3
    JeffB's Avatar
    JeffB
    JeffB is offline Senior Member
    Join Date
    Sep 2001
    Location
    Québec, Canada
    Posts
    1,923
    If you don't want hours and minutes, use the DATE() function

    JeffB
    CodeGuru VB FAQ Visual Basic Frequently Asked Questions
    VB Code color Tool to color your VB code on CodeGuru
    Before you post Importants informations to know before posting
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured