Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;