FIRST DAY OF YEAR

Description

Will take a date and convert the value to the first day of the year. Used in Quick Calculations for corresponding data field type.

Parameters

Options

Input Parameter Values	Input Values
Only Rollup If	Generic Criteria

Input

Input	Input Values	Required
Input 1	Column or Date Literal	✔

Remarks

The system takes the date value for a given month back to day 1 of the year. This calculation is often used to make it easier to construct the lower bounds of a year-to-date filter

Example

1. Input: 12/31/2017
2. Quick Calculations > Date > First Day of Year
3. Output: 01/01/2017