Difference between revisions of "Manuals/calci/DAY"

From ZCubes Wiki
Jump to navigation Jump to search
Line 13: Line 13:
  
 
==See Also==
 
==See Also==
 
 
*[[Manuals/calci/DATE  | DATE]]
 
*[[Manuals/calci/DATE  | DATE]]
 
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
 
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
 
  
 
==References==
 
==References==

Revision as of 23:44, 11 December 2013

DAY(sl.no)


  • where is the date of the day to find.

Description

  • This function gives the day of the month and also the day 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

Examples

  • DAY("12/11/2013") = 11
  • DAY("12-DEC-2012")=12

See Also

References