Hi all,
I have already added parameter filter date but it does not work. I filter the creation date of that GL based on field Batch.CreateDateTime as below.
Pls advise me if I misunderstand sth.
Thanks in advanced.
Answer
Why report Transaction for Period ( GL633000) can't filter by creation date of that GL?
Best answer by miguel80
Hi!
Try using two separate conditions for the date instead of the “between”. Something like “greater than or equal” to @FromDate AND “less than or equal” to @ToDate.
Let me know if that helped.
+3Hi!
Try using two separate conditions for the date instead of the “between”. Something like “greater than or equal” to @FromDate AND “less than or equal” to @ToDate.
Let me know if that helped.
Miguel Q
Hi!
Try using two separate conditions for the date instead of the “between”. Something like “greater than or equal” to @FromDate AND “less than or equal” to @ToDate.
Let me know if that helped.
Oh it’s right
+3Might be that the creation date has also the time so your parameter is being considered as 03.25.2023 00:00:00 which is less than 03.25.2023 11:15:32.
Miguel Q
Might be that the creation date has also the time so your parameter is being considered as 03.25.2023 00:00:00 which is less than 03.25.2023 11:15:32.
oh it’s make sense , thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.