Model

Truncate Dates to Month Start

Convert CSV dates to month starts in a reusable structured transform

Transforms ISO dates in orders.csv to the first day of their month in a new month_start column, retaining the original data and direct source lineage.

Choose how you start, and build beyond the Model. Packages, prices and purchase terms are held together on Pricing.

See packages and pricing

What this Model does.

A reusable CSV date transformation model that creates one structured transform, Month Starts, directly from orders.csv. It retains the original order and date columns and adds month_start, converting each ISO date to the first day of its month. Repeated runs reuse the existing transform. A change request can update it in place to use the first day of each year while keeping the same output column. Reset removes generated results and side effects while preserving the source CSV and model structure; a subsequent run restores the default month-start transformation.

What the Model brings.

Adds a month_start column

Retains order and date columns

Preserves direct CSV lineage

Reuses one Month Starts transform

Supports in-place year-start changes

Resets generated state cleanly

Build beyond it.

The Model joins your foundation. Bring your data, brand and business definitions together, then shape the next tool, channel or experience from what is already there.

Explore the platform

Explore more Models.

Browse the published Models