Question Re: Current Date as filter in Web Intelligence? in Technology Q&A

Current Date as filter in Web Intelligence?

former_member307980 — Thu, 25 Feb 2021 22:49:43 GMT

I know this question (or similar) has been raised, but each one has been unique, and I think my situation is similar, albeit could be more simple?

I have a WebI document with 4 data sources, and 4 corelating tabs, one for each source. None of the data elements or data sources point to anything with a "Current_Date" or the like.

What I need is this: I have a "Created_Date" field, and this field needs to equal "Current_Date."

I have added a variable on the report for current date, and formatted it the same as my "Created_Date" field.

I am trying to find a way if I can only select records that "Created_Date" = "Current_Date"

Is there a simple solution for this? Sorry if this is bringing up old questions but this one has been puzzling me.

I cannot provide screenshots.

Thank you in advance

Jared

Re: Current Date as filter in Web Intelligence?

ayman_salem — Fri, 26 Feb 2021 09:13:55 GMT

Your question is not clear enough to understand. Is Created_Date in your query (part of the data)? or is this the creation date of the report?

Re: Current Date as filter in Web Intelligence?

former_member307980 — Fri, 26 Feb 2021 14:13:33 GMT

Created_Date is part of the data set, and the variable I created Current Date is a variable I created on the webi report.

Re: Current Date as filter in Web Intelligence?

Loc — Mon, 10 Jan 2022 10:15:06 GMT

Hi Jared,

You can try the following:

1) create a variable that returns "True" when Created_Date = Current_Date

2) add this variable to your table in a hidden column

3) Filter the table on "True"