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.

Many Thanks in advance.

Fernando Costa

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.

Many Thanks in advance.

Fernando Costa

>

> 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.

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

>

> Many Thanks in advance.

> Fernando Costa

--

Greg Goebel ftp://fcext3.external.hp.com/dist/mxd/index.html

HP MXD Marketing http://hpislsup.lvld.hp.com (HP only)

pctm@lvld.hp.com http://www.geocities.com/CapeCanaveral/Launchpad/6000