basic/qa/vba_tests/dateadd.vb

   1 '
   2 ' This file is part of the LibreOffice project.
   3 '
   4 ' This Source Code Form is subject to the terms of the Mozilla Public
   5 ' License, v. 2.0. If a copy of the MPL was not distributed with this
   6 ' file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7 '
   8
   9 Option VBASupport 1
  10 Option Explicit
  11
  12 Function doUnitTest() As String
  13     TestUtil.TestInit
  14     verify_testDateAdd
  15     doUnitTest = TestUtil.GetResult()
  16 End Function
  17
  18 Sub verify_testDateAdd()
  19     On Error GoTo errorHandler
  20
  21     TestUtil.AssertEqual(DateAdd("m", 1, "1995-01-31"),    CDate("1995-02-28"), "DateAdd(""m"", 1, ""1995-01-31"")")
  22     TestUtil.AssertEqual(DateAdd("m", 1, "1995-01-31"),    CDate("1995-02-28"), "DateAdd(""m"", 1, ""1995-01-31"")")
  23     TestUtil.AssertEqual(DateAdd("m", 1, "1995-01-31"),    CDate("1995-02-28"), "DateAdd(""m"", 1, ""1995-01-31"")")
  24     TestUtil.AssertEqual(DateAdd("yyyy", 1, "1995-01-31"), CDate("1996-01-31"), "DateAdd(""yyyy"", 1, ""1995-01-31"")")
  25     TestUtil.AssertEqual(DateAdd("q", 1, "1995-01-31"),    CDate("1995-04-30"), "DateAdd(""q"", 1, ""1995-01-31"")")
  26     TestUtil.AssertEqual(DateAdd("y", 1, "1995-01-31"),    CDate("1995-02-01"), "DateAdd(""y"", 1, ""1995-01-31"")")
  27     TestUtil.AssertEqual(DateAdd("d", 1, "1995-01-31"),    CDate("1995-02-01"), "DateAdd(""d"", 1, ""1995-01-31"")")
  28     TestUtil.AssertEqual(DateAdd("w", 1, "1995-01-31"),    CDate("1995-02-01"), "DateAdd(""w"", 1, ""1995-01-31"")")
  29     TestUtil.AssertEqual(DateAdd("ww", 1, "1995-01-31"),   CDate("1995-02-07"), "DateAdd(""ww"", 1, ""1995-01-31"")")
  30
  31 Rem This fails when directly comparing using AssertEqual, probably due to rounding.
  32     TestUtil.AssertEqualApprox(DateAdd("h", 1, "1995-01-01 21:48:29"), CDate("1995-01-01 22:48:29"), 1E-10, "DateAdd(""h"", 1, ""1995-01-01 21:48:29"")")
  33
  34     TestUtil.AssertEqual(DateAdd("n", 1, "1995-01-31 21:48:29"), CDate("1995-01-31 21:49:29"), "DateAdd(""n"", 1, ""1995-01-31 21:48:29"")")
  35     TestUtil.AssertEqual(DateAdd("s", 1, "1995-01-31 21:48:29"), CDate("1995-01-31 21:48:30"), "DateAdd(""s"", 1, ""1995-01-31 21:48:29"")")
  36
  37     Exit Sub
  38 errorHandler:
  39     TestUtil.ReportErrorHandler("verify_testDateAdd", Err, Error$, Erl)
  40 End Sub