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.
HFLo asked 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.