Hi

I have a table which contains a date field....when the fields data
type is set to date/time the format changes to MM/DD/YYYY but
yet when the datatype is set to char the format is perfect......

Why does this happen?.....I'm using a SQL stmt in my VB app to
update the field......

Thanks