09-06-2005 05:17 PM
09-07-2005 08:55 AM
09-07-2005 09:09 AM
02-21-2006 03:43 PM
Brad,
I've been playing with DIAdem 9 a bit more this month along with your attached files. I'm wondering, how do we convert time that is already formated as a numeric in seconds since 1904, i.e. secs GMT from your attached files, to a timestamp formated as Time rather than numeric. For example I want to be able to view Secs GMT in mm/dd/yyyy hh:mm:ss.sssss. I'm currently messing with some solutions but your input would be helpful.
--cj
02-21-2006 05:17 PM
I think I might have finally figured it out. I entered the following formula into DIAdem's calculator
To calculate time given sec since 1.1.0000
ch(#):='Secs GMT'+60052924800+(363*86400)+(37256*86400)
To calculate time given sec since 1.1.1904
ch(#):='Secs GMT'+60052924800+(363*86400)
secs from year 0001 to 1904 60052924800
I don't know however, why I had to substract 2 days from a year.
02-22-2006 10:06 AM
Hi cmiranda,
Here's a VBScript library I use to convert values back and forth between date/time strings, DIAdem date/time numbers (since 0 AD) and VBScript date/time numbers (since 100 AD).
Hope that helps,
Brad Turpin
DIAdem Product Support Engineer
National Instuments