A anony Dec 15, 2004 #1 Hi, If I have a datetime, how do I display it as its13 digit numeric value? Thanks.
K Ken Tucker [MVP] Dec 15, 2004 #3 Hi, Now.ToOADate http://msdn.microsoft.com/library/d...tml/frlrfsystemdatetimeclasstooadatetopic.asp Ken --------------------- Hi, If I have a datetime, how do I display it as its13 digit numeric value? Thanks.
Hi, Now.ToOADate http://msdn.microsoft.com/library/d...tml/frlrfsystemdatetimeclasstooadatetopic.asp Ken --------------------- Hi, If I have a datetime, how do I display it as its13 digit numeric value? Thanks.
G Guest Dec 15, 2004 #4 Anony, A datetime's Ticks property contains the raw number that represents that datetime's date and time. Kerry Moorman
Anony, A datetime's Ticks property contains the raw number that represents that datetime's date and time. Kerry Moorman
J Jay B. Harlow [MVP - Outlook] Dec 16, 2004 #5 anony, What specifically do you mean by "its 13 digit numeric value"? Especially consider that a DateTime has more then 13 "digits" of data... (there are 21 "digits" of data... You could possible use DateTime.ToString to convert the elements of a DateTime to a string in the format you desire. Dim value As DateTime = DateTime.Now Debug.WriteLine(value.ToString("yyyyMMddHHmmssfffffff"), "now") For details on custom datetime formats see: http://msdn.microsoft.com/library/d...s/cpguide/html/cpcondatetimeformatstrings.asp For information on formatting in .NET in general see: http://msdn.microsoft.com/library/d...y/en-us/cpguide/html/cpconformattingtypes.asp Hope this helps Jay
anony, What specifically do you mean by "its 13 digit numeric value"? Especially consider that a DateTime has more then 13 "digits" of data... (there are 21 "digits" of data... You could possible use DateTime.ToString to convert the elements of a DateTime to a string in the format you desire. Dim value As DateTime = DateTime.Now Debug.WriteLine(value.ToString("yyyyMMddHHmmssfffffff"), "now") For details on custom datetime formats see: http://msdn.microsoft.com/library/d...s/cpguide/html/cpcondatetimeformatstrings.asp For information on formatting in .NET in general see: http://msdn.microsoft.com/library/d...y/en-us/cpguide/html/cpconformattingtypes.asp Hope this helps Jay
A anony Dec 16, 2004 #6 I was thinking of the time portion having 13 digits. Thanks to all who responded.