Difference between revisions of "Manuals/calci/DAYSBETWEEN"

Revision as of 11:56, 3 June 2015

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 $seconddate$ is before the $firstdate$ .

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 10: / Line 10: @@
 *This function will give the result as error when the <math>seconddate</math> is before the <math>firstdate</math>.
-==ZOS Section==
+==ZOS==
 *The syntax is to calculate DAYSBETWEEN in ZOS is <math>DAYSBETWEEN(firstdate,seconddate)</math>.
 *<math>firstdate</math> is the starting date.