Julian date to normal date

[Terry Curran]

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C2E3F4.C788EC80
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit


You will probably have to do some work on this. 

PowerHouse can easily convert a DATE into a Julian Date, but doesn't
seem to do it the other way around, in fact the conversion of DATE to
JDATE is documented in the manuals.

You will probably have to do some manipulation of your Julian Date to
strip out the year and the days part.

DEFINE j-date-year = FLOOR( jdate-field /1000 )
DEFINE j-date-days = MOD( jdate-field,1000 )
DEFINE start-of-year DATE = (j-date-year * 10000) + 101
DEFINE the-date DATE = DATE(DAYS(start-of-year) + j-date-days))

Of course this could probably be condensed into a single statement

DEFINE the-date DATE FORMAT YYYYMMDD = &
 
DATE(DAYS((FLOOR(jdate-field/1000)*10000)+101)+MOD(jdate-field,1000)))

I dare say someone will come up with a better solution sonner or later.

-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Richard French
Sent: Thursday, March 06, 2003 2:23 PM
To: powerh-l@cube.swau.edu
Subject: Julian date to normal date




Does anyone know how to convert a julian date ccyyjjj to ccyymmdd within
Quiz or Quick? 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

------=_NextPart_000_0000_01C2E3F4.C788EC80
Content-Type: text/x-vcard;
	name="Terence Phillip Curran (terry.curran@towermarsh.co.uk).vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Terence Phillip Curran (terry.curran@towermarsh.co.uk).vcf"

BEGIN:VCARD
VERSION:2.1
N:Curran;Terence;Phillip
FN:Terence Phillip Curran (terry.curran@towermarsh.co.uk)
ORG:TowerMarsh Ltd
TITLE:Managing Director
TEL;WORK;VOICE:+44 (2392) 503893
TEL;HOME;VOICE:+44 (2392) 503893
TEL;CELL;VOICE:+44 (7720) 562048
ADR;WORK:;;130 Parham Road;Gosport;Hants;PO12 4UE;United Kingdom
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:130 Parham Road=3D0D=3D0AGosport, =
Hants PO12 4UE=3D0D=3D0AUnited Kingdom
URL;WORK:http://www.towermarsh.co.uk
EMAIL;PREF;INTERNET:terry.curran@towermarsh.co.uk
REV:20030301T095201Z
END:VCARD

------=_NextPart_000_0000_01C2E3F4.C788EC80--