Nov 13, 2014 #1 jchewsmith Technical User Joined Nov 20, 2006 Messages 161 Location US how do you change a julian date time (41956.5467824074) to 11/13/2014 2:30 pm
Nov 13, 2014 1 #2 kray4660 MIS Joined Apr 7, 2008 Messages 1,054 Location US datetimevalue, but I get 11/13/2014 1:07:21PM. Upvote 0 Downvote
Nov 13, 2014 1 #3 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US ...and You do not have a Julian data referenced to January 1, 4713 BC. This is a Microsoft Date/Time SERIAL number. It is 41,956 DAYS since Dec 31 1899, referenced to January 1, 1900. Upvote 0 Downvote
...and You do not have a Julian data referenced to January 1, 4713 BC. This is a Microsoft Date/Time SERIAL number. It is 41,956 DAYS since Dec 31 1899, referenced to January 1, 1900.