Trying to add filter Today() on DetailSection

[CRgrp2]

Hello,

I'm having difficulties adding DetailSection filter using Today() variable.

I can filter successfully with hard coded date:
Field is: Value
Datatype: DateTime
Columm: TicketDate
equal to: 12/13/2022

But if I try using Expression:
Field is: Expression
(AttendSumm.TicketDate = Today) - returns no records

I've also tried (AttendSumm.TicketDate) == (Today)
and tried (AttendSumm.TicketDate = {Today})
and tried (AttendSumm.TicketDate) = Today())

Anyone have any suggestions? your help would be greatly appreciated!!!

thank you

[Lech Kulikowski]

Hello,

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

Thank you.

[CRgrp2]

Thank you for the reply, I've attached sample report.

[Lech Kulikowski]

Hello,

We couldn't open that file. It is not our report template format.

Thank you.

[CRgrp2]

Hello,

Attached few examples, and dictionary file. MRT report is saved as CFF when downloaded from erp application and I cant save directly within stimulsoft report designer.

Nonetheless, still trying to filter detail on DateTime field <TicketDate> when equal to <Today>.

Set "Field Is" = Expression
(AttendSumm.TicketDate = Today)

Apparently, syntax is incorrect?

[Lech Kulikowski]

Hello,

Should be (AttendSumm.TicketDate == Today)

Thank you.

[CRgrp2]

OMFG! Thank you!! That worked for me. (AttendSumm.TicketDate == Today)

I can't tell you how many different ways I tried to get this to work, anyhow it's now filtering. Thanks again for your help! Much appreciated.

[Max Shamanov]

Hello,

You are welcome!

[Essier12]

useful information

[Lech Kulikowski]

Hello

We are always glad to help!