Convert Julian date to regular date.

Convert this "1192043444" to 10/10/2007 3:10:44 PM
tvaeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
peter57rConnect With a Mentor Commented:
dateadd("s", 1192043444,#01/01/1970#)
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Julian >>

  That's not a Julian date.  A Julian date is in the format of   yyyyddd

  where 'yyyy' = year
             'ddd'  = nth day of the year.

JimD.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
My guess is it is a delta date;  a number of something (days, seconds, etc) off a base date.

Need more info on what your doing.

JimD
0
All Courses

From novice to tech pro — start learning today.