Delimiter expressions

[kjcochran]

Does anyone know if there is a delimiter expression in access?

[JoeM]

What do you mean?
What are you trying to do?

[kjcochran]

I am trying to separate a column that contains a date and a time into two seaparte columns.

I believe the DATEPART function will work for this, correct?

[JoeM]

I believe the DATEPART function will work for this, correct?

If it is truly entered as a date, then yes, that should work.
If it is entered as Text, then you will need to use functions like INSTR.