Load data which is less then today()

[bushpalaamarnat]

Hi, could any one help. 

I have been trying this for past 2 weeks now in different way. am trying to create a qvd file based on date, by function week start date. 

let vDateStamp = Text(date(today(), 'DD-MM-YYYY'));
let vDateStamp2 = Text(WeekStart((today()-46), 'DD-MM-YYYY'));

Weekload:

LOAD *,
//date(MakeWeekDate((2000+right(Week,2)),mid(Week,2,2),0), 'MM/DD/YYYY')+ 46 as WeekStart_Date2,
Date#(MakeWeekDate((2000+right(Week,2)),mid(Week,2,2),0), 'DD-MM-YYYY')as WeekStart_Date

FROM
[\\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\ICR_Load.qvd]
(qvd)
;

ICRLoad:
NoConcatenate
load
*,
Text(Date(WeekStart_Date,'DD-MM-YYYY')) as WeekStart

Resident Weekload;

ICR:
NoConcatenate
load
*
Resident ICRLoad
Where ("WeekStart" <= $(vDateStamp) )
and ("WeekStart" >= $(vDateStamp2))
;

STORE ICR into \\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\History.qvd(qvd);

Drop Tables Weekload;
Drop Tables ICRLoad;

[pradosh_thakur]

Check in the variable overview what value do you see for vDateStamp2.

[bushpalaamarnat]

let vDateStamp = date#(today() , 'DD-MM-YYYY'); //let vDateStamp2 = WeekStart((today()-46), 'DD-MM-YYYY'); Weekload: LOAD *, Date#(MakeWeekDate((2000+right(Week,2)),mid(Week,2,2),0), 'DD-MM-YYYY')as WeekStart_Date FROM [\\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\ICR_Load.qvd] (qvd) ; ICRLoad: NoConcatenate load *, WeekStart(date(WeekStart_Date,'DD-MM-YYYY')) as WeekStartdate Resident Weekload; ICR: NoConcatenate load * Resident ICRLoad Where ("WeekStartsate" <= $(vDateStamp) ) //and ("WeekStartdate" >= $(vDateStamp2)) ; STORE ICR into \\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\History.qvd(qvd); Drop Tables Weekload; Drop Tables ICRLoad;

let vDateStamp = date#(today() , 'DD-MM-YYYY');
//let vDateStamp2 = WeekStart((today()-46), 'DD-MM-YYYY');

Weekload:

LOAD *,

Date#(MakeWeekDate((2000+right(Week,2)),mid(Week,2,2),0), 'DD-MM-YYYY')as WeekStart_Date

FROM
[\\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\ICR_Load.qvd]
(qvd)
;

ICRLoad:
NoConcatenate
load
*,
WeekStart(date(WeekStart_Date,'DD-MM-YYYY')) as WeekStartdate

Resident Weekload;

ICR:
NoConcatenate
load
*
Resident ICRLoad
Where ("WeekStartsate" <= $(vDateStamp) )
//and ("WeekStartdate" >= $(vDateStamp2))
;

STORE ICR into \\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\History.qvd(qvd);

Drop Tables Weekload;
Drop Tables ICRLoad;