Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''DAYSBETWEEN(fd,sd)'''</div><br/> | <div style="font-size:30px">'''DAYSBETWEEN(fd,sd)'''</div><br/> | ||
| − | *where | + | *where <math>fd</math> is the starting date and <math>sd</math> is the second (final )date |
==Description== | ==Description== | ||
*This function gives the number of days between the first date and the second date(30 days in 12 months). | *This function gives the number of days between the first date and the second date(30 days in 12 months). | ||
| − | *Here | + | *Here <math>fd</math> and <math>sd</math> are two dates to find the number of in between days. |
| − | *Also | + | *Also <math>fd</math> and <math>sd</math> we have to give in DATE function format. |
==Examples== | ==Examples== | ||
| Line 20: | Line 20: | ||
==References== | ==References== | ||
| − | |||
Revision as of 07:06, 19 November 2013
DAYSBETWEEN(fd,sd)
- where is the starting date and is the second (final )date
is the starting date and 
is the second (final )dateDescription
- This function gives the number of days between the first date and the second date(30 days in 12 months).
- Here and are two dates to find the number of in between days.
- Also and we have to give in DATE function format.
Examples
- DAYSBETWEEN("2/28/2008","3/13/2008")=15
- DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366