Wrong Date

Results 1 to 2 of 2

Thread: Wrong Date

  1. #1
    Join Date
    Dec 1969

    Default Wrong Date

    I am creating a asp forum and when a user replies to a message I have a SQL statement entering the current date and time that works fine followed by a SQL statement that updates the LastPostDate with the current date except that for some unknown reason the date comes up as 30/12/1899 and it also inserts a time in the LastPostTime even though i&#039ve not asked it to. <BR>I have done a repsonse.write statement and the SQL is correct. <BR>

  2. #2
    Steve Cimino Guest

    Default RE: Wrong Date

    Are you using Access?<BR><BR>I&#039m not very familar with Access anymore, but I remember a person in here posting that the default date is 12/30/1899. He found his answer in the help file. I can&#039t remember what the solution was, but you may want to check past posts in this forum for the answer.

Posting Permissions

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