Difference between revisions of "Manuals/calci/DAY"
Jump to navigation
Jump to search
Line 18: | Line 18: | ||
*DAY("12/11/2013") = 12 | *DAY("12/11/2013") = 12 | ||
*DAY("12-DEC-2012")=13 | *DAY("12-DEC-2012")=13 | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|dsJh0EOg5K0|280|center|DAY}} | ||
==See Also== | ==See Also== |
Revision as of 20:34, 26 May 2015
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
ZOS Section
- 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).
Examples
- DAY("12/11/2013") = 12
- DAY("12-DEC-2012")=13