Difference between revisions of "Manuals/calci/JULIANDATE"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''JULIANDATE (GregorianDate)'''</div><br/> *<math>GregorianDate</math> is any Gregorian date value. ==Description== *This function used to conver...") |
|||
| 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 Range values also. For Example: JULIANDATE(#8/15/2017-12/15/2017). | ||
| + | * #date notation needs mm/dd/yy format . | ||
==Examples== | ==Examples== | ||
Revision as of 13:31, 15 May 2018
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 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