rhernand Registered User. Local time Today, 01:17 Joined Mar 28, 2003 Messages 96 Jun 17, 2003 #1 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.
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.
Fornatian Dim Person Local time Today, 01:17 Joined Sep 1, 2000 Messages 1,396 Jun 17, 2003 #2 Why not use the dateadd function to add 100 years?
rhernand Registered User. Local time Today, 01:17 Joined Mar 28, 2003 Messages 96 Jun 17, 2003 #3 dateadd By adding 100 years with the dateadd function, will it only display the new date or can I update the db also?
dateadd By adding 100 years with the dateadd function, will it only display the new date or can I update the db also?
Fornatian Dim Person Local time Today, 01:17 Joined Sep 1, 2000 Messages 1,396 Jun 18, 2003 #4 Use an update query, be careful what records you select or you may end up more screwed up than you started.
Use an update query, be careful what records you select or you may end up more screwed up than you started.
rhernand Registered User. Local time Today, 01:17 Joined Mar 28, 2003 Messages 96 Jun 18, 2003 #5 Update Thanks, this worked great
