Avatar of garyrobbins
garyrobbins
Flag for United States of America asked on

Date Time Formattin, CSV, EXCEL, ACCESS

I have a CSV file that gives the datetime as a text cell 20150615160228000  and i need to convert it to date time in access querry.

Need to convert to 06/15/2015 16:02:28

Below is what i tried but not working.

CDate(Mid([ColumnX],5,2) & "/" & Right([ColumnX],2) & "/" & Left([ColumnX],4) & " " & Mid([ColumnX],9,2) & ":" & Mid([ColumnX],11,2) & ":" & Mid([ColumnX],13,2))

The below works when it is just the date.

Dispense Date: CDate(Mid([ColumnY],5,2) & "/" & Right([ColumnY],2) & "/" & Left([ColumnY],4))
Microsoft AccessMicrosoft Office

Avatar of undefined
Last Comment
garyrobbins

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Gustav Brock

This is a bit simpler:

DispenseDate: CDate(Format(Left([ColumnX], 14), "@@@@\/@@\/@@ @@\:@@\:@@"))

/gustav
garyrobbins

ASKER
AHHHHHH,   I should have caught that.  Thank you!!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes