Q:

2007-06-17 09:05:34.813 - date format needs conversion

Need this format: 2007-06-17 09:05:34.813 modified in MS Access to be like this:
mm/dd/yyy hh:nn:ss AM/PM
Tried this in my Access query: 
"newdate": Format([newdate],"yyyy/mm/dd hh:nn:ss")
but it's not working.

A:

Source format is not a date, so your formula doesn't work. You need to remove number after dot:
Format(Left([newdate],InStr(1,[newdate],".")-1),"yyyy/mm/dd hh:nn:ss AMPM")

