Forum Discussion
Solved
limit the connect live data date
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?
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.
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.