Problem with Sharepoint time format in Access

Copper Contributor

Hi,

 

I've a Sharepoint list with date time format (dd/mm/yyyy hh:mm:ss). When I open this list in Access, I see all the dates and times correctly except for the time 0:00:00. If the time is 0:00:00, Access shows only the date without the time. Anybody can help me, please?

 

Exemple:

Time in Sharepoint list: 10/12/2020 15:45  -> Time in Access table: 10/12/2020 15:45:00

Time in Sharepoint list: 10/12/2020 0:00  -> Time in Access table: 10/12/2020

 

Thanks for your help

 

0 Replies