Creating reports and dashboards | Stimulsoft community forum

I'm trying to convert a datetime field to a Date type (without the time) so I can then compare it with a date parameter.

At the moment this is what I'm selecting from the datasource:

SELECT ApptDate
FROM Diary

I have then tried to apply a filter to the report to check if column field ApptDate is equal to expression Date (being the parameter variable).

I have also tried the following filter expression:

{Format("{0:MM.dd.yyyy}", Diary.ApptDate)} = Date

but it returned errors.


Can you point me in the right direction please? Surely this can't be too difficult.
Crystal Reports has a Date() function that allows this. Is this something you can look to build in future?

Hello,

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

Thank you.