During optimizing our application, I have separated dates into day, month year and time, In the application I have added the fields as date. While exporting the date into excel its showing as text and not in date.
Can you explain how you separated the dates into day, month, year and time? Did you create separate fields for each of them in a calendar table? What do you mean by adding the fields as date? Did you do a MakeDate(Year,Month,Day)?
