Difference between revisions of "Manuals/calci/DAYINDEX"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''DAYINDEX (Value)'''</div><br/> *<math>Value</math> is any date value. ==Description== *This function shows the date value as a number. *In <mat...")
 
 
(3 intermediate revisions by one other user not shown)
Line 5: Line 5:
 
*This function shows the date value as a number.
 
*This function shows the date value as a number.
 
*In <math>DAYINDEX(Value)</math>,<math>Value</math> is any date value.
 
*In <math>DAYINDEX(Value)</math>,<math>Value</math> is any date value.
*Here date value displaying as a number.
+
*The function displays the date value in the range of 1 to 31, from the given date.
*So here displaying the date value from 1 to 31 from the given date.
+
*DD/MM/YYYY format can also be used. For Example:"14/5/2005[DD/MM/YYYY]".
 +
*Range values can also be used. For Example: DAYINDEX(#9/27/2000-11/25/2000).
 +
* #date notation needs  mm/dd/yy format .
  
 
==Examples==
 
==Examples==
 
# 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
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=QD9OL3ghgFk|280|center|Day Index}}
  
 
==See Also==
 
==See Also==

Latest revision as of 06:50, 15 February 2019

DAYINDEX (Value)


  • is any date value.

Description

  • This function shows the date value as a number.
  • In , is any date value.
  • The function displays the date value in the range of 1 to 31, from the given date.
  • DD/MM/YYYY format can also be used. For Example:"14/5/2005[DD/MM/YYYY]".
  • Range values can also be used. For Example: DAYINDEX(#9/27/2000-11/25/2000).
  • #date notation needs mm/dd/yy format .

Examples

  1. DAYINDEX("9/27/2000") = 27
  2. DAYINDEX("2/4/1976") = 4
  3. DAYINDEX("19/7/2017[DD/MM/YYYY]") = 19

Related Videos

Day Index

See Also

References

DATE