[bug] Report Module issue in date based filters (YYYY-MM-DD format only works and other date format returns incorrect results)

[RajasekaranJeni]

Hi,

I tried to create the report with some date filters. For example create the report for the opportunities module. initially created the report without any conditions. All the data are displayed.

Initial date format in the user preference is set to YYYY-MM-DD. And records are filtered based on the start date. (between two dates)

The date format is set to DD-MM-YYYY. Now records are filtered using the same condition. (start date and between two dates). When the date format is changed, there is no results are shown.

when the user preference is mentioned in the format as DD-MM-YYYY. but when we enter the dates in format of YYYY-MM-DD format it display the records in the preview section. But unable to save the reports. It returns the error as "Please enter valid date".

The date with after condition, always return all the records.

When the date used with before condition, it doesnt return any records.

The date filter is working good with YYYY-MM-DD format . Its not working in DD-MM-YYYY format only.

Kindly provide the solution for the same.

Thanks & regards,
Rajasekaran.