Update FoxPro DB

rhernand

Registered User.
Local time
Today, 01:17
Joined
Mar 28, 2003
Messages
96
I am accessing a FroPro DB. It has a Date/Time field with SOME bogus fields (01/01/1900) instead of (01/01/2000). Is there a query I can run to only change the CC part of the MM/DD/CCYY field in the DB.
 
Why not use the dateadd function to add 100 years?
 
dateadd

By adding 100 years with the dateadd function, will it only display the new date or can I update the db also?
 
Use an update query, be careful what records you select or you may end up more screwed up than you started.
 

Users who are viewing this thread

Back
Top Bottom