Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
*<math>seconddate</math> is the end date. | *<math>seconddate</math> is the end date. | ||
*For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222. | *For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222. | ||
| + | {{#ev:youtube|uzjJ_2v2MVw|400|center|Days between}} | ||
==Examples== | ==Examples== | ||
Revision as of 05:02, 13 June 2014
DAYSBETWEEN(firstdate,seconddate)
- Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle firstdate} is the starting date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle seconddate} is the end date.
Description
- This function gives the number of days between the first date and the second date(30 days in 12 months).
- Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle firstdate} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle seconddate} are two dates to find the number of in between days.
- Also Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle firstdate} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle seconddate} we have to give in DATE function format.
- This function will give the result as error when the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle seconddate} is before the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle firstdate} .
ZOS Section
- The syntax is to calculate DAYSBETWEEN in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DAYSBETWEEN(firstdate,seconddate)} .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle firstdate} is the starting date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle seconddate} is the end date.
- For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222.
Examples
- DAYSBETWEEN("2/28/2008","3/13/2008")=15
- DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366