FIRST DAY OF MONTH

Description

Will take a date and convert the value to the first day of the month. 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 month. This calculation is often used to make it easier to construct the lower bounds of a month-to-date filter.

Example

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