You want to select last week from a field in the application, right? If so, create an inline field with two values like :
Load * Inline [
Now use this WeekSel field for selection in the publisher/server.
Thanks for your reply. With inline table I am able to select the last week but its not giving the current year. Its giving irrespective of all years.
I have created the same flag in script level as below its working fine.
if( Year(Today())=year(Date),if( Week(Today())-1 =Week(Date),1,0)) as [Last Week],