On my system, I have many reports where I use datetime fields inside datawindows. I have a functionality by which I export the data. For this I use the SaveAs () method, with the CSV! and Clipboard!
The problem is that when opening the csv file or pasting the clipboard in Excel, it doesn't recognize the datetime fields as valid dates.
An alternative would be to modify the datetime fields by date, but the datawindows are very many.
Any ideas on how to make excel recognize the dates as valid?
Regards and thank you all.