Unable to create One View Pivot Table with Date

We are using EOne 9.1 Tools Release 9.2

I'm using the One View Inventory Valuation Analysis Inquiry and I'm trying to create a pivot table with the next count date, location, and number of items to count (see attached) (my example uses the Quantity on Hand which wouldn't be used to accomplish this but I wanted to rule out counting the Item number as the issue.

When I design the report it looks like what I want but when I run the report I get an error.  Any idea's on how to fix this error?

Thank you

Becky

I found the correct formatting, it was actually quite simple but thought I would share in case someone runs across the same thing.  If you click on the column and go to properties, select Oracle as the formatting style and Type SHORT in the formatting mask this will for the date m/d/yy, if you want to use another format simply add a date to a data table and change the format using the format dropdown in the toolbar then check the properties for that column to see what was assigned, that will give you the formatting that you want.