Calendar

[smilingjohn]

Hi All

I have a excel file which has the date from 01-01-201 to 17-11-17

I have createed  the master calendar , But its not working  from the actual date .

Can someone suggest me wher iam gpping wrong ? Please find the attachment  of the excel file and qvw

[MK_QSL]

What is the exact problem you are facing?

[smilingjohn]

hi Manish

If u look at the table  in my dashbaord attached above , the date conversion is not happening for the given date .

In my excel i dont have date starting from 2014 it in the master calendar it is starting from 2014.

And also ther is no conversion happening for my actaul date , which is from 2016

[engishfaque]

Dear John,

2014 is coming from listed below variable, please check

LET vStartDate = Num(YearStart(Today(), -1));

Kind regards,

Ishfaque Ahmed

[tamilarasu]

Check the attachment

[PrashantSangle · Accepted solution]

Hi,

update your below variable and try

let vStartDate=Num(Peek('Date',0,'date'));

let vEndDate=Num(Peek('Date',-1,'date'));

Regards

[engishfaque]

Dear John,

Kindly find attached document, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed