Storage of Time/Date Values
Datameer stores and calculates dates as UNIX Time and uses the 1900 date system. Dates are converted into milliseconds (returning the difference between the current time and midnight, January 1, 1970 UTC).
|Date||Unix Time Conversion|
|Jan 1,1970 00:00:01||1|
|Jan 1,2016 00:00:01||1451606401|
A constant is an identifier whose associated value cannot typically be altered by the program during its execution.
Examples of time/date constants
Example of Date/Time constants within functions
*Today is October 10, 2012
|Function(s)||Result||Function with constant||Result|
|TODAY()||Oct 10, 2012 12:00:00 AM||TODAY()-5h||Oct 09, 2012 07:00:00 PM|
|TODAY()||Oct 10, 2012 12:00:00 AM||TODAY()+8h+5m||Oct 10, 2012 08:05:00 AM|
Example of Date/Time constant within a filter
Apply a Filter and choose Advanced
Type in the filter you wish to apply including time constant if needed.
#UserDates!Time >= ASDATE("01-05-2012";"MM-dd-yyyy")+5d
View the data on the filtered sheet
Example of Date/Time constant within a formua
Open a calculation workbook sheet and create your formula
(#UserDates!Time) <= ASDATE("01-05-2012";"MM-dd-yyyy")+48h || (#UserDates!Time) >= ASDATE("01-20-2012";"MM-dd-yyyy")-48h
View the formula results
Modify values with a data date type using the ADDTODATE function. This function allows for both adding and subtracting from dates and times and takes daylights savings time and leap years into account.
Operators (+/-) outside the ADDTODATE function are not supported.