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))
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
Last Comment
garyrobbins
ASKER CERTIFIED SOLUTION
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.
ASKER
AHHHHHH, I should have caught that. Thank you!!
DispenseDate: CDate(Format(Left([ColumnX
/gustav