How do I seperate Date and Time text data within an access field (Split or remove)
Posted on 2004-04-08
Help. I need to break a specific field in a database up.
My DB file has about 10 fields such as first,last,phone,address, etc. My date field contains both the date and time in the string. For example "1/1/2004 1:00am". It contains about 400,000 records. I would like it to read "1/1/2004", removing or separating the "1:00am" portions.
I need to separate the date from the time within that particular "Date" field. I will then de dupe by date. (I am presently unable to dedupe the file because the 'time' portion of the "Date" field causes the entire field to be unique).
How can I spit the field into 2 fields or remove the 'time' portion entirely?
I am an access novice so please write your instructions with patience and detail in mind.