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  .

ZOS Section

  • 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

See Also

References