the time value for 8:12AM is
?cdbl(#08:12:00#)
0.341666666666667
bears no relation to
10.02702
Going back to the original post, not clear what
means - are you linked to sql server, receiving a download as a .csv? or something else
If you are linked then updating the ODBC driver might solve the problem - see this link as an example
https://social.msdn.microsoft.com/Fo...databasedesign
otherwise google something like 'datetime2 in Access'
Edit: if you want the science behind how datetime and datetime2 vary in how they are determined
https://towardsdatascience.com/datet...t-70e50ae2bab9
SO might be possible to work it backwards, but I don't have the time
right now