Manuals/calci/DAYSBETWEEN

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 $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$.
  • 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 $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

Examples

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

Related Videos

DAYS360

See Also

• DAYS360
• DATE
• DAY

References

• 360DAYS

• List of Main Z Functions

• Z3 home