Expressions and formulas

[kjcochran]

Is there a way to use a convert use a "text to column" function in access that separates at a fixed width?



I have an access table (that I can't change) that includes the data and time in the same column and I want to separate the two (date and time) in a query. I can't use the "Left" function because my date isn't a consistent 10 characters.

[June7]

Try Format function.

Format([date field],"MM/DD/YYYY")
or
Format([date field], "Short Date")

Format([date field], "hh:nn:ss AM")
or
Format([date field], "Long Time")