Difference between revisions of "DateToJulian"
Jump to navigation
Jump to search
m (Reverted edits by 176.8.90.7 (talk) to last revision by 194.84.116.138) |
|||
| Line 1: | Line 1: | ||
Returns a numerical value corresponding to the Julian Date equivalent of the specified date. | Returns a numerical value corresponding to the Julian Date equivalent of the specified date. | ||
| − | The date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month. | + | The date is specified in the ''YYYMMdd'' format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month. |
| − | Julian Date indicates the number of days that have elapsed since January 1st, 1900. | + | Julian Date indicates the number of days that have elapsed since January 1st, 1900, making it a useful function for performing calculations with dates. |
| − | + | == Usage == | |
<syntaxhighlight>DateToJulian(YYYMMdd)</syntaxhighlight> | <syntaxhighlight>DateToJulian(YYYMMdd)</syntaxhighlight> | ||
| − | Where: | + | Where: |
| − | + | ||
| − | + | :'''YYYMMdd''' - a numerical expression, specifying the date in YYYMMdd format. | |
| − | |||
| − | |||
| − | + | == Notes == | |
| − | + | * Use [[JulianToDate]] to convert the Julian date back to the regular [[Date]] format. | |
| + | == Examples == | ||
| + | <syntaxhighlight>DateToJulian(1080101)</syntaxhighlight> | ||
| + | Will return a value of 39448, corresponding to the specified date of January 1st, 2008. | ||
| + | <syntaxhighlight>DateToJulian(990402)</syntaxhighlight> | ||
| + | Will return a value of 36252, corresponding to the specified date of April 2nd, 1999. | ||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] | ||
Revision as of 12:41, 19 February 2012
Returns a numerical value corresponding to the Julian Date equivalent of the specified date.
The date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month.
Julian Date indicates the number of days that have elapsed since January 1st, 1900, making it a useful function for performing calculations with dates.
Usage
DateToJulian(YYYMMdd)
Where:
- YYYMMdd - a numerical expression, specifying the date in YYYMMdd format.
Notes
- Use JulianToDate to convert the Julian date back to the regular Date format.
Examples
DateToJulian(1080101)
Will return a value of 39448, corresponding to the specified date of January 1st, 2008.
DateToJulian(990402)
Will return a value of 36252, corresponding to the specified date of April 2nd, 1999.
