import { NOW, DATEVALUE, TODAY } from "../../src/Formulas/Date" import * as ERRORS from "../../src/Errors"; import { assertEquals, catchAndAssertEquals, test, lockDate } from "../Utils/Asserts" test("NOW", function(){ lockDate(2012, 11, 10, 4, 55, 4); assertEquals(NOW(), 41253.45490740741); lockDate(1999, 11, 10, 4, 55, 4); assertEquals(NOW(), 36504.45490740741); lockDate(1999, 9, 22, 4, 55, 4); assertEquals(NOW(), 36455.41324074074); lockDate(1944, 1, 2, 1, 11, 55); assertEquals(NOW(), 16104.29994212963); catchAndAssertEquals(function() { NOW.apply(this, [12]); }, ERRORS.NA_ERROR); }); test("TODAY", function(){ lockDate(2012, 11, 10, 4, 55, 4); assertEquals(TODAY(), DATEVALUE("Dec 10 2012")); lockDate(1999, 11, 10, 4, 55, 4); assertEquals(TODAY(), DATEVALUE("Dec 10 1999")); lockDate(1999, 9, 22, 4, 55, 4); assertEquals(TODAY(), DATEVALUE("Oct 22 1999")); lockDate(1944, 1, 2, 1, 11, 55); assertEquals(TODAY(), DATEVALUE("Feb 2 1944")); catchAndAssertEquals(function() { TODAY.apply(this, [12]); }, ERRORS.NA_ERROR); });