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!

Convert text "yyyymmdd" to date/time data type? 1

Status
Not open for further replies.
wvmbark

wvmbark

Technical User
Feb 12, 2003
135
US
What is the expression I'd use in an update query to convert a text field that contains "yyyymmdd" to a date/time data type?
 
Sort by date Sort by votes
Try:
DateSerial(Left([TextField],4), Mid([TextField],5,2), Right([TextField],2))

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
766
dhookom
dhookom
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
558
mikrom
mikrom
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
240
OzFoxy
OzFoxy
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
848
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top