Project and Portfolio Management Practitioners Forum
cancel

Excel reports: date values

Highlighted
Erik Cole
Acclaimed Contributor.

Excel reports: date values

Is there a secret to getting dates in the data to be dates in the spreadsheet? Do you have to format the column in the template first?

I have a report running against a portlet data source that is returning a date column, but in the Excel report they are formatted as text and cannot be changed; you have to add a new column and perform datevalue() on it....