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==