BigJimSlade
Registered User.
- Local time
- Today, 23:43
- Joined
- Oct 11, 2000
- Messages
- 173
Hey, Big Jim here:
I have two columns in a table. It looks like this
COLUMN A COLUMN B
20020215
20020312
20020421
Both A and B are text fields. When I attempt to use the MID, LEFT, and RIGHT Functions to UPDATE COLUMN B to show the date as "02/15/02", I get a Type Conversion Failure and no updates occur. B
Both A and B are TEXT fields. Any thoughts here?
Thanks in advance!
Big Jim
I have two columns in a table. It looks like this
COLUMN A COLUMN B
20020215
20020312
20020421
Both A and B are text fields. When I attempt to use the MID, LEFT, and RIGHT Functions to UPDATE COLUMN B to show the date as "02/15/02", I get a Type Conversion Failure and no updates occur. B
Both A and B are TEXT fields. Any thoughts here?
Thanks in advance!
Big Jim