Question Re: Webi Query Filter - Between Formula in Technology Q&A

Webi Query Filter - Between Formula

JG432 — Tue, 29 Jul 2025 16:17:14 GMT

Hello Community,

I am trying to find a way to filter on my 'CreationDate' field to only return entries created from seven days ago (from current date) to current date. I've tried creating a 'detail' object with no luck. I have converted my 'CreationDate' field to a date field using the 'ToDate' function (varCreationDate), and then applying : =[varCreationDate] Between (RelativeDate(CurrentDate(); -7); CurrentDate())

with many different syntax and iterations ran through Galileo AI with no luck. This seems like it should be a fairly intuitive, I'm hoping it is an easy fix! Thanks as always!!!

Re: Webi Query Filter - Between Formula

bekart — Wed, 30 Jul 2025 09:43:57 GMT

in report you can build variable which will check the days between and flag them.
For example:
=If(DaysBetween([CREATIONDATE];CurrentDate())>=0 And DaysBetween([CREATIONDATE];CurrentDate())<=7) Then "show" Else "hide"

Re: Webi Query Filter - Between Formula

bekart — Wed, 30 Jul 2025 09:35:48 GMT

hi, does your query is based on SQL?
If so use filter on query you can use FHSQL statement in WHERE clause:

CREATIONDATE>=sysdate()-7

not sure about the date format so bear in mind that trunc may be necessary.

Re: Webi Query Filter - Between Formula

JG432 — Wed, 30 Jul 2025 14:03:34 GMT

I unfortunately do not have access to use a SQL query. That 'would' be ideal

Re: Webi Query Filter - Between Formula

JG432 — Wed, 30 Jul 2025 14:05:42 GMT

@bekart, is there a way to only return the values in which the 'creationdates' are in between the present day and seven days ago? Thank you for your reply as well

Re: Webi Query Filter - Between Formula

JG432 — Wed, 30 Jul 2025 15:46:33 GMT

Basically, is there a way to set the between dates on a date query filter to be dynamic?

Re: Webi Query Filter - Between Formula

JG432 — Wed, 30 Jul 2025 21:41:19 GMT

Your earlier post: =If(DaysBetween([CREATIONDATE];CurrentDate())>=0 And DaysBetween([CREATIONDATE];CurrentDate())<=7) Then "show" Else "hide"

worked out! I just had to set the filter after that to exclude "hide"

Thank you!!!

Re: Webi Query Filter - Between Formula

bekart — Thu, 31 Jul 2025 13:03:06 GMT

happy to hear that - good practise is to limit data on query level but in your case you are not able to do so. So filtering data on report level is the correct solution.