Difference between revisions of "Manuals/calci/DAYSBETWEEN"

Latest revision as of 13:34, 22 May 2018

DAYSBETWEEN(firstdate,seconddate)

$firstdate$ is the starting date.
$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 and are two dates to find the number of in between days.
Also and we have to give in DATE function format.
This function will give the result as error when the is before the .
- We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".

ZOS

The syntax is to calculate DAYSBETWEEN in ZOS is .
is the starting date.
is the end date.
For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222.

Days between

Examples

=DAYSBETWEEN("2/28/2008","3/13/2008")=15
=DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366

References

360DAYS

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''DAYSBETWEEN(fd,sd)'''</div><br/>
+<div style="font-size:30px">'''DAYSBETWEEN(firstdate,seconddate)'''</div><br/>
-*where 'fd' is the starting date and 'sd' is the second (final )date
+*<math>firstdate</math> is the starting date.
+*<math>seconddate</math> 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 FD and SD are two dates to find the number of in between days.
+*Here <math>firstdate</math> and <math>seconddate</math> are two dates to find the number of in between days.
-*Also FD and SD we have to give in DATE function format.
+*Also <math>firstdate</math> and <math>seconddate</math> we have to give in [[Manuals/calci/DATE | DATE]] function format.
+*This function will give the result as error when the <math>seconddate</math> is before the <math>firstdate</math>.
+**We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
+==ZOS==
+*The syntax is to calculate DAYSBETWEEN in ZOS is <math>DAYSBETWEEN(firstdate,seconddate)</math>.
+*<math>firstdate</math> is the starting date.
+*<math>seconddate</math> is the end date.
+*For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222.
+{{#ev:youtube|uzjJ_2v2MVw|280|center|Days between}}
 ==Examples==
+*=DAYSBETWEEN("2/28/2008","3/13/2008")=15
+*=DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366
-*DAYSBETWEEN("2/28/2008","3/13/2008")=15
+==Related Videos==
-*DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366
+{{#ev:youtube|4CfTkI37jaM|280|center|DAYS360}}
 ==See Also==
+*[[Manuals/calci/DAYS360 | DAYS360]]
+*[[Manuals/calci/DATE | DATE]]
+*[[Manuals/calci/DAY | DAY]]
-*[[Manuals/calci/COLUMNS | COLUMNS]]
+==References==
-*[[Manuals/calci/ROW | ROW]]
+*[http://en.wikipedia.org/wiki/360-day_calendar| 360DAYS]
-==References==
-[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]