The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel reports: date values

Highlighted
Erik Cole
Honored 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....

//Add this to "OnDomLoad" event