Dates cells filter in exported Excel reports

[Abed Hamodi]

Dears @ Support,

Please assist with an issue we are having. When exporting a report to an excel file and the report contains a date field, excel is not recognizing it as a proper date field. We found that we cannot properly filter the date fields. Only after making any change to the field will excel recognize it as a date field and we can filter it normally. Please see the below screenshots and attached files.

Can you please help?
Thanks in advance

[HighAley]

Hello.

We know about this issue.
We need more time to find a solution.
We will let you know when we get nay result.

Thank you.

Ticket reference: #58

[ratmo]

Was this ever Solved?

We are also having the same issue

[MariusNel]

Hi Any feedback regarding this fix?

[Lech Kulikowski]

Hello,

Please check the last release build.

Thank you.

[MariusN]

Hello,

Please check the last release build.

Thank you.

I have the latest build, but still does the same. What must I do different, please advise?

Set the Text Format as Date and still in Excel I can not sort?

Thank you in advance.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis

Thank you.

[MariusN]

Hi,

USING MSSQL as DATA Source.

Can not add example data, but added the exported Excel report and the Stimulsoft report. (Data is sensitive)

Thank you in advance.

[Lech Kulikowski]

Hello,

Please send test data for your report.

Thank you.

[MariusN]

Hello,

Please send test data for your report.

Thank you.

Can you not just use the data from the Excel Spreadsheet?

OR

How do you want the data? CSV or MSSQL Table?