Converting Date Format - Existing Records

[amourdevin]

I imported a large Excel sheet into Access. I also have ASP scripts used as an interface. The script generates the error "Type mismatch: 'EW_UnFormatDateTime'". I believe the original creator the Excel spreadsheet used a custom date format in some places and not others. My question is is there a way to convert all my existing records to a general date format?

Thanks in advance!

 

[DougP]

you can try a couple of things

first make a copy of the data
once converted it won't go back.

try changing the field type to text then to date.

you could create a function like so. This goes in a module

Public Function MyDate(DateField)
MyDate = Format(DateField, "mm/dd/yy&quot
End Function

cal it in your query like so
=MyDate([DateField])
where DATEFIELD is the date that is messed up

DougP, MCP