# VRF-Need Help..intermittent results.

Question asked by VRFuser on Apr 11, 1999
Latest reply on Apr 11, 1999 by VRFuser
Fernando Costa wrote:
>
> Dear All,
>
> I have been trying to find an equivalent for the HP Series 200/300 commands
> DATE and TIME which will convert between any given Date & Time and Julian
> Time expressed in seconds.  I cannot seem to find an equivalent function in
> VEE to do this.  I would appreciate if anyone could help me out either with
> a formula or an equivalent function(s) in VEE.

>From my notes:

---------------------------------------------------------------------------

* After going through a lot of trouble to build a Julian-date function,
a VEE user at the European Space Agency came up with a far cleaner
one:

+------------------------------------------------------+
|                       Formula                        |
+---+--------------------------------------------------+
| A | 1 + IntPart(( A - dmytodate(1,1,year(A))/86400)) |
+---+--------------------------------------------------+

This subtracts the time value (in seconds) at the beginning of the first
day of the year from the current time value, then divides that by the
number of seconds in the day (60 * 60 * 24 = 86,400), takes the integer
part of the result, and adds 1 to get the day of the year.

Much simpler ... though I did have some fun learning about how the
calendar works when I did it the hard way: did you know that there
are actually proposals to make the year 13 months of 28 days each
(with various adjustments thrown in once or twice a year)? Interesting
idea, but I won't hold my breath waiting to see if it will happen.

---------------------------------------------------------------------------

>