R rodneyb Registered User. Local time Today, 22:21 Joined Jul 3, 2003 Messages 84 Dec 23, 2003 #1 I am trying to update a date field in a database table with a text value from another table via sql. what is the best way to convert a string which has format "yyyymmdd" to a date field?
I am trying to update a date field in a database table with a text value from another table via sql. what is the best way to convert a string which has format "yyyymmdd" to a date field?
W WayneRyan AWF VIP Local time Today, 22:21 Joined Nov 19, 2002 Messages 7,120 Dec 23, 2003 #2 Rodney, See the CDate function. There should be examples here or in Access Help. Wayne
