You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

SUBTRACT PERIOD FROM DATE


This function calculates a new date by subtracting a specified period from a specified date.


Syntax

date - number period



Inputs
  • date - The date that you want to subtract the specified period from.
  • number - Specifies how many periods you want to subtract from the date.
  • period - A keyword that specifies which time unit to subtract. Valid units are DAYS, WEEKS, MONTHS and YEARS.


Return type

  • date


Examples

ExpressionResultType
01-01-2015 – 1 DAYS31-12-2014Date
01-01-2015 – 1 WEEKS25-12-2014Date
01-01-2015 – 1 MONTHS01-12-2014Date
01-01-2015 – 1 YEARS01-01-2014Date



Back to Top



  • No labels