Differences

This shows you the differences between two versions of the page.

--- syntax:functions:makedate [2015/04/03 20:54] – elenap
+++ syntax:functions:makedate [2021/09/11 00:11] – craigt
@@ Line 1: / Line 1: @@
-===== MakeDate(year, month, day) =====
+======  MakeDate(year, month, day) ======
+Category:  Date and Time function
-Creates a new date, represented as number, from //year//, //month// and //day//.
+\\
+=====Description=====
+This function returns a date serial number based on the //year//, //month// and //day// numberic values.
-^  Example  ^  Result  ^
+\\
-|  makedate(2014,1,1)  |  41640  |
+=====Arguments=====
-|  makedate(1945,5,9)  |  16566  |
+^Argument^Type^Description^
+|year|Number|A number value representing the 4-digit year of the date.|
+|month|Number|A number value representing the month (1 to 12) of the date).|
+|day|Number|A number value representing the day-of-the-month number (1 to 31).|
-=== See also ===
+**Return value type:** Date serial number
+\\
+=====Examples=====
+  makedate(2014, 1, 1)  //Returns 41640 (Equivalent to January 1st, 2014.)
+  makedate(2020, 2, 28)  //Returns 43889 (Equivalent to February 28th, 2020.)
+\\
+=====See also=====
+  * [[syntax:functions:date|Date(date, format)]]
+  * [[syntax:functions:format|Format(datetime, format)]]
-  * [[syntax:functions:format]]
-  * [[syntax:functions:date]]