Storage of Time/Date Values
Datameer stores and calculates dates as UNIX Time. 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.