General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Converting dates to have the century
I have a .dbf free table that has dates as 01/01/06. This seems to be causing a "database engine failue" when I use this dbf as my data source in a Word Mail Merge. (I selected dbase files). I know the fix is to SET CENTURY ON in the code before creating the .dbf. But how do I converted my 01/01/06 to 01/01/2006 in my existing .dbf?
Brenda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only