#2642 - Excel Sheets and date problem!
I recently encountered strange behavior when exporting documents to excel sheets and only thing that I can correlate this with is Security Suite and perhaps Suite CRM database issue. When I use export as admin feature I don't have a problem dates are normally shown in Excel sheets.
But if I change the user rights to "regular user" and allow the same user to export full data using roles and security suite groups, exported dates are converted to text starting from random numbers. What's even worse I cannot change this at all no matter what I do. If I use format and set columns to "dates" or paste as values and convert to dates or when I use text to columns feature in Excel.
This is a problem when you are exporting 8000 records and you want to filter out dates according to some year or similar, it will give you wrong figures.
Looking forward to your reply.