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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-24 : 09:42:13
|
| Andre writes "Hi everyone, my problem sounds simple but I've never done this.The Date Format problem!I have three columns in my table named tbl_Birthday of data in MS Access:Table name: tbl_BirthdayID_Bdate | myDate | Bdate 6543 | | 19750420 4534 | | 19760214I'm working in Access and I want to write a query that takes the "Bdate" column is formated for TEXT, with the dates in the rows as above. The "myDate" column is in Date/Time format and I want to take all the dates in the "Bdate" column and put them in the myDate column but have it insert it into the "myDate" column in the format like: "04/20/1975" with slashes WHERE the "BDate" data refers to the "ID_Bdate". In a nutshell, when I move the "Bdate" to the "myDate" column it has to be in the right row where the "ID_Bdate" - simply just move the date over to the row next to it in the right format.Any one please help! Thanks all!Andre" |
|
|
|
|
|
The DATE Format problem???