Excel Report Builder and Date Field
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.