Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
update your below variable and try
let vStartDate=Num(Peek('Date',0,'date'));
let vEndDate=Num(Peek('Date',-1,'date'));
Regards
What is the exact problem you are facing?
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
Dear John,
2014 is coming from listed below variable, please check
LET vStartDate = Num(YearStart(Today(), -1));
Kind regards,
Ishfaque Ahmed
Check the attachment
Hi,
update your below variable and try
let vStartDate=Num(Peek('Date',0,'date'));
let vEndDate=Num(Peek('Date',-1,'date'));
Regards
Dear John,
Kindly find attached document, I hope you are looking for that one.
Kind regards,
Ishfaque Ahmed