Hi there,

I have a formula in a form that displays a date in a list view report that I have created. It displays as a date with no problem there. 

However, when I try to include the same formula result in a pivot table, it's not showing up as a date but rather as text.

What do I need to do to this formula so that I can have it display as a date in both my list report as well as when I am trying to build a pivot table report around it?

Thanks.