Differences

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

--- syntax:types [2016/11/21 21:35] – dmitry
+++ syntax:types [2017/12/23 09:44] – dmitry
@@ Line 2: / Line 2: @@
 Any value in EasyMorph can be either number or text or boolean or error. Unlike databases, one column of a table in EasyMorph can hold values of different types, similarly to Excel. Although, keep in mind that most [[syntax:functions]] expect their arguments to be of certain type.
 ==== Numbers ====
 Numbers are either integer or decimal numbers with fixed decimal point. Floating point numbers are not supported. Effective range is (-7.9 x 10<sup>28</sup> to 7.9 x 10<sup>28</sup>) / (10<sup>0 to 28</sup>) which is 28-29 significant digits with or without decimal point between them.
@@ Line 17: / Line 18: @@
 To convert text values to numbers see [[syntax:functions:asnumber]] function.
+==== Dates ====
+Notice that there is no dedicated type for dates in EasyMorph. Instead, as in Excel, dates are numbers, but only formatted as dates. Such number date represents a number of days since January 1st, 1900. For instance 42680 corresponds to November 6th, 2016, because there are 42680 days from January 1st, 1900 to that date.
+Dates in expressions can be specified using date literals. A date literal has format #yyyy-MM-dd. For example:
+<code>#2016-11-06</code>
+is the same as 42680 and corresponds to November 6th, 2016. Here is an example of date literals in a condition:
+<code>[Date] >= #2016-10-01 and [Date] <= #2016-12-31</code>
+Because dates are numbers, there is no need in using a special function for adding days. To get the next day just add 1. However, there is a special function for adding months — [[syntax:functions:addmonths|addmonth()]].
 ==== Text ====