84 Posts


8.7K Points

Thu, Dec 6, 2018 3:57 PM

No Status

Strip the year out of a date in a Transform task

Hey folks!

I am looking for a way to strip just the year out of a date when performing a Transformation task in a query builder. i.e. If the date is 1/1/2014 I'd like the transform task to output "2014".

The reasoning is a cool holiday e-card for our large, long standing customers. We want to show them where they were when they started (seat count, etc.), their growth over that time (current - initial seats), along with the billboard top song, top grossing movie, and Apple released in that year (were an Apple software company).

Any thoughts?