Difference between revisions of "Manuals/calci/JULIANDATE"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
meaning 2,451,919 elapsed days since the beginning of the Julian cycle. | meaning 2,451,919 elapsed days since the beginning of the Julian cycle. | ||
*So this function is converting Gregorian date in to Julian date. | *So this function is converting Gregorian date in to Julian date. | ||
| + | *We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]". | ||
*We can use Range values also. For Example: JULIANDATE(#8/15/2017-12/15/2017). | *We can use Range values also. For Example: JULIANDATE(#8/15/2017-12/15/2017). | ||
* #date notation needs mm/dd/yy format . | * #date notation needs mm/dd/yy format . | ||
| Line 19: | Line 20: | ||
# JULIANDATE("10/1/2000") = 2451818.5 | # JULIANDATE("10/1/2000") = 2451818.5 | ||
# JULIANDATE("3/31/1700") = 2342060.5 | # JULIANDATE("3/31/1700") = 2342060.5 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=s7uVlGS1pJg|280|center|Julian Date}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:51, 15 February 2019
JULIANDATE (GregorianDate)
- is any Gregorian date value.
is any Gregorian date value.Description
- This function used to convert the Gregorian date in to Julian date format.
- In , is any gregorian date.
- A Julian date or day number is the number of elapsed days since the beginning of a cycle of 7,980 years.
- The starting point for the first Julian cycle began on January 1, 4713 B.C.
- Julian dates are widely used as time variables .It is assumed that 7-day weeks have formed an uninterrupted sequence since ancient times.
- Thus, the day of the week can be obtained from the remainder of the division of the Julian date by 7.
- A Julian date or day number for a certain time of day on January 9, 2001, looked like this 2451919.3423000001348555
,meaning 2,451,919 elapsed days since the beginning of the Julian cycle.
- So this function is converting Gregorian date in to Julian date.
- We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
- We can use Range values also. For Example: JULIANDATE(#8/15/2017-12/15/2017).
- #date notation needs mm/dd/yy format .
Examples
- JULIANDATE("8/15/2017") = 2457980.5
- JULIANDATE("10/1/2000") = 2451818.5
- JULIANDATE("3/31/1700") = 2342060.5