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?
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