Auto Date Create Column

Results 1 to 2 of 2

Thread: Auto Date Create Column

  1. #1
    Join Date
    Dec 1969

    Default Auto Date Create Column

    I created a web based manager through which I create and edit tables in a SQL database. Everything is fine except that I can&#039;t make the data/time fields automatically enter the date and time when I add a record. The quasi manual way of AddRS(DateTime) = Now isn&#039;t very elegant and prone to problems. Can anybody suggest the syntax for creating a column with auto date/time?<BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Auto Date Create Column

    make sure the default value for the column is GetDate() on SQL or Now() on Access

Posting Permissions

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