Current Date as filter in Web Intelligence?

[former_member307980]

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

[ayman_salem]

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?

[former_member307980]

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

[Loc]

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"