Skip to content


Excel Report Builder and Date Field

HFLo asked 8 years ago
Excel Builder report when exported to Excel, date field are not recorngize as Date. Please advice.
Jared replied 8 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.