Milliseconds

[gblack]

Can access pull in a date time field down to the milliseconds? If so how? What function can I use to pull in a text field and convert it to a date field with the milliseconds displayed?

I get a string in from Oracle. It looks something like this:

2003050213392322
yyyymmddhhnnss??

Thus far I have change it to a date by doing something like this:
Call_Time: CDate(Mid([START_TIME],5,2) & "/" & Mid([START_TIME],7,2) & "/" & Mid([START_TIME],3,2) & " " & Mid([START_TIME],9,2) & ":" & Mid([START_TIME],11,2) & ":" & Mid([START_TIME],13,2))

But I can't add the milliseconds...

I want to throw that into access and turn it into a dateTime field, without loosing the milliseconds. How can I do this? Cdate? Format? I'm not sure how to go about it...



Thanks,
G

 

[jfgambit]

The only thing I could find about this was the following:

MS Knowlegde - Milliseconds

 

[gblack]

Um

Ya, that works when the field is already formatted, with Ms (Milliseconds) already understood by Access in a dateTime field.

I need to know how to pull a string into access and convert it into a dateTime field without loosing the Ms.

Thanks though, I appreciate the research!

G