Trying to add filter Today() on DetailSection
Trying to add filter Today() on DetailSection
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
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
- Attachments
-
- FilterToday-detailSection.png (95.7 KiB) Viewed 1140 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Trying to add filter Today() on DetailSection
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: Trying to add filter Today() on DetailSection
Thank you for the reply, I've attached sample report.
- Attachments
-
- (AttendSumm.TicketDate = Today())_backup.zip
- (6.97 KiB) Downloaded 117 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Trying to add filter Today() on DetailSection
Hello,
We couldn't open that file. It is not our report template format.
Thank you.
We couldn't open that file. It is not our report template format.
Thank you.
Re: Trying to add filter Today() on DetailSection
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?
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?
- Attachments
-
- Detail Filter.png (105.99 KiB) Viewed 1087 times
-
- Detail Filter2.png (100.86 KiB) Viewed 1087 times
-
- Dictionary (1).zip
- (1.73 KiB) Downloaded 117 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Trying to add filter Today() on DetailSection
Hello,
Should be (AttendSumm.TicketDate == Today)
Thank you.
Should be (AttendSumm.TicketDate == Today)
Thank you.
Re: Trying to add filter Today() on DetailSection
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.
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.
-
- Posts: 786
- Joined: Tue Sep 07, 2021 10:11 am
Re: Trying to add filter Today() on DetailSection
Hello,
You are welcome!
You are welcome!
Re: Trying to add filter Today() on DetailSection
useful information
Last edited by Essier12 on Fri Dec 23, 2022 2:42 pm, edited 2 times in total.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Trying to add filter Today() on DetailSection
Hello
We are always glad to help!
We are always glad to help!