Datavju
Datavju

Model

Extract Year from Dates

Add a year column from ISO-formatted dates

Extract the first four characters of the included ISO date strings into a year column. Keep event and date fields, and optionally show year and month in that same output column.

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.

Make the year easy to inspect alongside each event. The included CSV uses dates in YYYY-MM-DD format; Run copies their first four characters into year without changing the source fields. This is text extraction for the stated date format. Change uses the first seven characters to show YYYY-MM. Reset removes generated output and keeps the original event data.

What the Model brings.

Keep the original event and date

Add the year as a separate field

Switch to year-and-month extraction

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