writer
6,694
edits
Changes
no edit summary
*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 .
# 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==