Help my data to limt on the user fed date . Please help .

[prahlad_infy]

Helo Seniours ,

I want to show only those data in my table which is of last week to the date selected by me plus next week data

last week data-UserFeddate-Nextweek data .

Thank you in advancing .

[tresesco]

That is because of date format issue you have in your data. Try like:

Sum({<DateE={">=$(=Date(vDateselected-14,'DD/MM/YYYY')) <=$(=Date(vDateselected+14,'DD/MM/YYYY'))"}>}Sales)

[prahlad_infy]

I make change to your given exprns

Sum({<Week={">=$(=vWeekSelected-2) <=$(=vWeekSelected+2)"}>}Sales) and i am selcting 9 jan 2018 then if we minus 2 week , it should get  data from last week of 2017 , but it is not coming

i am fully not understanding sir .

[tresesco · Accepted solution]

The problem arises because you are referencing inter-year weeks. For such cases, you should rather use date field along with perhaps weekstart(), weekend() like:

Sum({<DateE={">=$(=Date(WeekStart(vDateselected,-2),'DD/MM/YYYY')) <=$(=Date(WeekEnd(vDateselected,2),'DD/MM/YYYY'))"}>}Sales)