Manuals/calci/DAYSBETWEEN

DAYSBETWEEN(firstdate,seconddate)


  • is the starting date.
  • 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

Related Videos

DAYS360

See Also

References