Creating reports and dashboards | Stimulsoft community forum

Hi,

1. I'm trying to filter data in DataBand by setting the date in format "dd.MM.yyyy", which is used in Russia.
The filter doesn't work. When I set the date in format "MM.dd.yyyy", it works fine.

I've set both (1) the report's Culture = Russian (ru-Ru), and (2) AutoLocalizationOnRun = true, still the filter doesn't work for "dd.MM.yyyy" format.

2. Also, how can I use the date in filtering expression? The code above doesn't work, due to the error: Operator '>=' cannot be applied to operands of type 'System.DateTime' and 'string'

Thank you.

Hello.

In your expression you compare the date with a string. Do you have the data as a string? In other way you should get a error.
You should use the DateTime variable to compare the dates or use the simplified interface.

Thank you.

I've solved most of my issues. Just to inform others who will face the similar problems:

The right way of using date in filtering expressions: Still, is it possible to use "dd.MM.yyyy" date format in the simplified interface?
"MM.dd.yyyy" works fine, but this format isn't conventional for our users.

Thank you.

Hello,

Can you please send us simple report with test data which reproduces the issue with date formatting for analysis.

Thank you.

Hi Aleksey,

There are report and source files in attachment.
The steps to reproduce my issue are in the header of the report.

Thank you.

Hello,

We couldn't reproduce this bug. Could you explain your issue in more details?

Also, please check modified report.

Thank you.