sql date for msaccess
sql date for msaccess
(OP)
Is there a sql way to convert data "01/04/2008 1430" to appear as 2008/04/01?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: sql date for msaccess
SELECT Mid(yourTextField,7,4) & Mid(yourTextField,3,4) & Left(yourTextField,2)
FROM yourTable
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: sql date for msaccess
Mid(left(Job.LastModified, 10), 5, 8) & '/' & Mid(left(Job.LastModified, 10), 3, 2) & '/' & Mid(left(Job.LastModified, 10), 1, 2)
AS Dates