Difference between revisions of "Manuals/calci/DAYSBETWEEN"

Latest revision as of 13:34, 22 May 2018

DAYSBETWEEN(firstdate,seconddate)

This function gives the number of days between the first date and the second date(30 days in 12 months).
Here $firstdate$ and $seconddate$ are two dates to find the number of in between days.
Also $firstdate$ and $seconddate$ 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]".

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

Days between

@@ Line 9: / Line 9: @@
 *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 Section==
+==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("2/28/2008","3/13/2008")=15
-*DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366
+*=DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366
+==Related Videos==
+{{#ev:youtube|4CfTkI37jaM|280|center|DAYS360}}
 ==See Also==
@@ Line 27: / Line 34: @@
 ==References==
 *[http://en.wikipedia.org/wiki/360-day_calendar| 360DAYS]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]