Results 1 to 3 of 3

Thread: wrong date

  1. #1
    Join Date
    May 2002
    Posts
    20

    Unanswered: wrong date

    I have a field, (ex: 18-05-1901) that because of the bug 2k2 the year is 1901 when it should be 2001... now the problem is... there are about 25000 records with this problem in 3 diferent tables ... what is the best way of change all the records? I know tha has to ne programmed..i don't now is how..

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Why not try a find and replace, in the table itself. Set find to 1901 anypart of field and replace to 2001. I would not autoreplace, rather click through.

    Although this can be done in code, sometimes it is safer by hand.

  3. #3
    Join Date
    May 2002
    Posts
    20
    very thanks dynamictiger glad to had your help

Posting Permissions

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