Date/Time field in Access 2010 modified in Sharepoint list

[pradeepiyer]

I have a table in my Access 2010 Database with few date/time fields. I have set different formats like Short Time, Medium Time etc. But when I link this table to Sharepoint list, all the date/time fields have been modified to their default format (General Date).

Is there a way we can keep the formats as such even after linked to Sharepoint list? If not, is there a workaround?

 

[pradeepiyer]

Anybody to help??

 

[namliam]

I dont have any experience with Sharepoint, which is why I havent responded previously.

Dates inside access are stored in general date, as such I can imagine unless you hard format the dates/times in a query they are exported the way they are stored.... not displayed... a format is but a format to the database and of no intrest to the data.

Same goes for Logical fields will be 0/1 instead of true/false and the same goes for "bigger" databases like Oracle and others.