The "data" worksheet has the correct date format -mm/dd/yy. There is no time
stamp

When in the pivot table worksheet the date is showing up as :00, :01,
:02...... What appears to be a truncated time format.

I have tried to set the date format in both the data worksheet and the pivot
table worksheet with no changes evident. The data worksheet will change but
this is not carried over to the pivot table worksheet.

Setting the format in the pivot table worksheet has no effect.

Any suggestions??