Difference between revisions of "Manuals/calci/TODATE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''TODATE (DayIndex)'''</div><br/> *<math>DayIndex</math> is any number from 1 to 7. ==Description== *This function shows the name of day for the ...")
 
 
Line 18: Line 18:
 
# TODATE(0) = 0
 
# TODATE(0) = 0
 
# TODATE(7) = Saturday
 
# TODATE(7) = Saturday
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=D1AKuWDWOrY|280|center|Date}}
  
 
==See Also==
 
==See Also==

Latest revision as of 14:57, 15 February 2019

TODATE (DayIndex)


  • is any number from 1 to 7.

Description

  • This function shows the name of day for the given Index number.
  • In , is the any number from 1 to 7.
  • The names of the 7 days of the week in most Latin-based languages come from the Roman calendar, which related each day with 7 celestial bodies considered to be gods: the Sun, the Moon, Mercury, Venus, Mars, Jupiter, and Saturn.
  • The 7-day-week provides a clear method of representing dates and times to avoid misinterpretation between people from different countries with varying traditions for writing numeric dates and times.
  • According to the international standard,Monday is the first day of week.
  • Although this is the international standard, several countries, including the United States, Canada, and Australia consider Sunday as the start of the week.
  • So in this function first day of the week is considered as SUNDAY.
  • Second day of the week is MONDAY and so on.
  • This function will return the result as error when the parameter value is other than 1 to 7.

Examples

  1. TODATE(3) = Tuesday
  2. TODATE(1) = Sunday
  3. TODATE(0) = 0
  4. TODATE(7) = Saturday

Related Videos

Date

See Also

References