Pivot Table Dates

Marvin Daniels

I've created a pivot sheet using the Pivot App that includes a date of when a call was taken, however I'm having no success creating an actual date column from the column created by the Pivot App. Please see below for formula reference.

Temp4 proves that Call Date, which is the primary column is not a date, which is expected for a primary column.

In Temp1-Temp3 break that date into year, month, and day values.

However when I attempt to reassemble using DATE() in an actual date column, I receive an #invalid data type.

The Date column is formatted as date.

What am I missing? 🧐

Marvin Daniels

I've solved my own problem. I needed to wrap my LEFT, MID and RIGHT functions with a VALUE function.

Marvin Daniels

I've solved my own problem. I needed to wrap my LEFT, MID and RIGHT functions with a VALUE function.