Convert Julian date to real date

[Guest]

I need a query to convert the julian date of 726488 to a real date 1/21/1990
i don't seem to get the right answer I believe I need to use the gregorian
calendar to do so but I can't figure out the formula.

 

[Rick B]

Not sure where you got "726488". It is not a Julian Date.

FIXED 32893
COMPL 67107
GREGORIAN 01/21/90
JULIAN 90021
YEAR 1990
COMPL 906061
DAY SUNDAY
MONTH JANUARY

 

[Guest]

Sorry my mistake 761324 is equal to today.

Not sure where you got "726488". It is not a Julian Date.

FIXED 32893
COMPL 67107
GREGORIAN 01/21/90
JULIAN 90021
YEAR 1990
COMPL 906061
DAY SUNDAY
MONTH JANUARY

 

[John Vinson]

Sorry my mistake 761324 is equal to today.

How is this date calculated? Days from January 1, 79 BCE is what I get
with some quick calculations; that's not one of the standard Julian
dates (astronomical JD, modified astronomical JD, etc.) that I'm
familiar with!

You cannot use 79 BCE as an anchor point (Access dates only go back to
January 1, 100 CE), but you should be able to pick an "anchor" date -
January 1, 2000 perhaps would be equivalent to 759339 (if I've got
this right).

You could then use an expression

DateAdd("d", [JDate] - 759339, #1/1/2000#)

to get the date/time value from one of your Julian dates, or

759339 + DateDiff("d", #1/1/2000#, [Realdate])

to calculate the julian date corresponding to the Access date/time
value Realdate.

DO check my math, it was done in haste.

John W. Vinson[MVP]

 

[Michel Walsh]

Hi,


The number you supplied seems roughly be equal to the number of minutes
since January First, 2004. Some synchronization protocols indeed tic each
minutes, maybe you read the data "straight" from the data stream, before it
get a chance to be decoded by the appropriate driver? or something similar?

If it is the number of minutes since January First 2004, use

DateAdd("n", number, #01-01-2004#)


to get a standard date.



Hoping it may help,
Vanderghast, Access MVP