Skip to content


Excel Report Builder and Date Field

HFLo asked 10 years ago
Excel Builder report when exported to Excel, date field are not recorngize as Date. Please advice.
Jared replied 10 years ago

There are a couple ways to make Excel recognize your data as a date.

1. In Excel set a new column to have a date format and then use a formula to convert your source column to a numeric date.  You would then hide the source column.  The formula is simply taking the source column multiplied by 1. For example, =J2*1.

2. You could modify the view to pass a date rather than a string in SQL.

If you would like to submit an answer or comment, please sign in to the eOne portal.