Difference between revisions of "Manuals/calci/DAYINDEX"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
*Here date value displaying as a number. | *Here date value displaying as a number. | ||
*So here displaying the date value from 1 to 31 from the given date. | *So here displaying the date value from 1 to 31 from the given date. | ||
| + | *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: DAYINDEX(#9/27/2000-11/25/2000). | *We can use Range values also. For Example: DAYINDEX(#9/27/2000-11/25/2000). | ||
* #date notation needs mm/dd/yy format . | * #date notation needs mm/dd/yy format . | ||
| Line 13: | Line 14: | ||
# DAYINDEX("9/27/2000") = 27 | # DAYINDEX("9/27/2000") = 27 | ||
# DAYINDEX("2/4/1976") = 4 | # DAYINDEX("2/4/1976") = 4 | ||
| + | # DAYINDEX("19/7/2017[DD/MM/YYYY]") = 19 | ||
==See Also== | ==See Also== | ||
Revision as of 13:31, 22 May 2018
DAYINDEX (Value)
- is any date value.
is any date value.Description
- This function shows the date value as a number.
- In , is any date value.
- Here date value displaying as a number.
- So here displaying the date value from 1 to 31 from the given date.
- 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: DAYINDEX(#9/27/2000-11/25/2000).
- #date notation needs mm/dd/yy format .
,Examples
- DAYINDEX("9/27/2000") = 27
- DAYINDEX("2/4/1976") = 4
- DAYINDEX("19/7/2017[DD/MM/YYYY]") = 19
See Also
References