Manuals/calci/DAY

DAY(Value)


  • where is the date of the day to find.

Description

  • This function gives the day of the specified date.
  • The day is the integer which is from 1 to 31.
  •   is the date of the day and the dates should be entered in the DATE function format.
  • i.e DATE(2014,1,7) for 7th day of January, 2014.
  • So we have to use this function like DAY("7-JAN-2014") or DAY("1-7-2014") is 7.
  • We can use Range values also. For Example: DAY(#JUN/7/2014-JUL/15/2014).
  • #date notation needs mm/dd/yy format .

ZOS

  • The syntax is to calculate DAY in ZOS is  .
  •   is the date of the day to find.
  • For e.g:DAY(#7-JUN-2014..15-JUN-2014).
Day

Examples

  • =DAY("12/11/2013") = 11
  • =DAY("12-DEC-2012")= 12
  • =DAY("14/8/2030[DD/MM/YYYY]") =14

Related Videos

DAY

See Also

References