Table of Contents

LAST DAY OF YEAR

Description

Will take a date and convert the value to the last day of a year.

Parameters

Options

Input Parameter Values Input Values
Only Rollup If Generic Criteria

Input

Input Input Values Required
Input 1 Column or Date Literal

Remarks

Used in Quick Calculations for corresponding data field type. This calculation is often used to make it easier to construct the upper bounds of a full year filter

Example

  1. Input: 04/15/2016
  2. Quick Calculations > Date > Last Day of Month
  3. Output: 12/31/2016