Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2004
    Location
    Cavite,Philippines
    Posts
    31

    Unanswered: Need Help(Updating Year in a Date field)

    Can someone help me how to update all data in a table that convert all dateyear to 2006 or other year??
    I'm using dbase IV

    I've tried this one but I got a Syntax error.
    RS.Open "UPDATE Mcordet set year(dteact_old)=2006", dbconn, adOpenDynamic, adLockOptimistic

    Please help.
    tnx.
    Last edited by crystal30; 02-04-05 at 01:20.

Posting Permissions

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