limit the connect live data date

[Rehab_hassan]

Hi All,

I am trying to limit te date range when i am connecting live to my coroprate data, I just need the last 5 years, how to do that?

[pbeye · Accepted solution]

Hi @Rehab_hassan ,

Would filtering down in the "Edit Query" section work for you? I can get it to work for me doing this:

• I click on "Edit Query" on my connection
• select the drop down on the date field
• click on Date/Time filters
• click Custom at the bottom
• Change the fields from "Equals" to "is in the previous" and update to 5 years.