Text

[Richard G]

I have a date / time field in a table which has be imported as part of a dataset unfortunately its in a text format ie: "25/01/2007 1100" Is there anyway I can get a query or report to read this ? The data is imported and creates a .csv file. When importing I have tried the comma seperated / delimited width command to seperate the date / time into two seperate fields but without success.

Regards

Richard

 

[Moniker]

This:

CDate("25/01/2007 11:00")

Will output this:

01/25/2007 11:00:00 AM

in a date format.

If you don't need the time value, take the first ten characters of the text string and use CDate on that:

CDate(Left("25/01/2007 11:00",10))