Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
acid_bratt
Starting Member
13 Posts |
Posted - 2003-10-08 : 04:02:03
|
Hi! I have 2 tables (TEMP & PROD) in MS Access. I have a text field in TEMP table wherein the records are dates but in yyyymmdd format. I want to insert all the records from TEMP table into PROD table but the field's data type is date/time and not text. Is there a way I can do that (as if I can convert/cast that field like in SQL)?Thanks so much.. |
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-10-08 : 05:17:58
|
Try the CDATE function, it usually works with dates in yyyymmdd format.Owais Make it idiot proof and someone will make a better idiot |
 |
|
|
|
|