Changing datatype

[YouMust]

Hello, my apologies it's me again.

I'm trying to change a field from long text to date/time (StartDate) to suit the actual data.

the data in the field is like this: 31/12/1999 - 24:59:99
and my format is: dd/mm/yyyy - hh:nn:ss

It works fine in a new field(test), but when applying it to a currently populated field access says it will delete all content in 148 records(all records).

I've uploaded a copy of the table
http://www.filedropper.com/acp

thanks in advance

 

[isladogs]

So your day has more than 24 hours?
If you are trying to convert data with errors, Access may well delete them as the record doesn't fit the rules for that datatype

 

[plog]

What I would do is not convert it to a date, but instead add a new field to your table. Make that new field a date datatype and do an UPDATE query to move the data from the existing string field to the new date field. That way you keep existing data and you can determine which records has errors.

 

[YouMust]

So your day has more than 24 hours?
If you are trying to convert data with errors, Access may well delete them as the record doesn't fit the rules for that datatype

ops bit of a typeo there sorry.


Thanks plog! I guess thats the only way