Creating reports and dashboards | Stimulsoft community forum

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

Hello,

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

Thank you.

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

Hello,

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

Thank you.

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?

Hello,

Should be (AttendSumm.TicketDate == Today)

Thank you.

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.

Hello,

You are welcome!

useful information

Hello

We are always glad to help!