Manuals/calci/DAY

DAY(Value)

• where $Value$ is the date of the day to find.
  • DAY(), converts a serial number to a day of the month.

Description

• This function gives the day of the specified date.
• The day is the integer which is from 1 to 31.
• $Value$ 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 the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
• 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 $DAY(VALUE)$.
• $Value$ 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
• =DAY(#7/06/2014..10/06/2014) = 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23...............

Related Videos

DAY

See Also

• DATE
• DATEVALUE

References

• Day

• List of Main Z Functions

• Z3 home