Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Date data from text format to Date format

Status
Not open for further replies.
allenEd

allenEd

Technical User
Nov 14, 2002
129
GB
Hi, I have a data base which I have to convert a "date" field which is in Text format, to a date format.

Currently all data is displayed as (sample)

"August 6, 2002"

Many thanks in Advance....

Allen
 
Sort by date Sort by votes
Try using the CDate function.

Hope This Help
PH.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
522
linuxguyEastCoast
linuxguyEastCoast
Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
2K
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top