Difference between revisions of "Manuals/calci/DAY"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''DAY( | + | <div style="font-size:30px">'''DAY(Value)'''</div><br/> |
| − | *where <math> | + | *where <math>Value</math> is the date of the day to find. |
| + | |||
==Description== | ==Description== | ||
| − | *This function gives the day of the | + | *This function gives the day of the specified date. |
| − | *<math> | + | *The day is the integer which is from 1 to 31. |
| + | *<math>Value</math> is the date of the day and the dates should be entered in the [[Manuals/calci/DATE| DATE]] function format. | ||
*i.e DATE(2014,1,7) for 7th day of January, 2014. | *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 <math>DAY(VALUE)</math>. | ||
| + | *<math>Value</math> is the date of the day to find. | ||
| + | *For e.g:DAY(#7-JUN-2014..15-JUN-2014). | ||
| + | |||
==Examples== | ==Examples== | ||
| − | |||
*DAY("12/11/2013") = 11 | *DAY("12/11/2013") = 11 | ||
*DAY("12-DEC-2012")=12 | *DAY("12-DEC-2012")=12 | ||
| + | |||
==See Also== | ==See Also== | ||
Revision as of 01:08, 18 April 2014
DAY(Value)
- where is the date of the day to find.
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") = 11
- DAY("12-DEC-2012")=12