Problem with Sharepoint time format in Access

%3CLINGO-SUB%20id%3D%22lingo-sub-1780439%22%20slang%3D%22en-US%22%3EProblem%20with%20Sharepoint%20time%20format%20in%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1780439%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20a%20Sharepoint%20list%20with%20date%20time%20format%20(dd%2Fmm%2Fyyyy%20hh%3Amm%3Ass).%20When%20I%20open%20this%20list%20in%20Access%2C%20I%20see%20all%20the%20dates%20and%20times%20correctly%20except%20for%20the%20time%200%3A00%3A00.%20If%20the%20time%20is%200%3A00%3A00%2C%20Access%20shows%20only%20the%20date%20without%20the%20time.%20Anybody%20can%20help%20me%2C%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExemple%3A%3C%2FP%3E%3CP%3ETime%20in%20Sharepoint%20list%3A%2010%2F12%2F2020%2015%3A45%26nbsp%3B%20-%26gt%3B%20Time%20in%20Access%20table%3A%2010%2F12%2F2020%2015%3A45%3A00%3C%2FP%3E%3CP%3ETime%20in%20Sharepoint%20list%3A%2010%2F12%2F2020%200%3A00%26nbsp%3B%20-%26gt%3B%20Time%20in%20Access%20table%3A%2010%2F12%2F2020%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1780439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New 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