Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys ,
How can i add a calander date as filter having all dates to choose between
My date field does not have all dates availble and user need to choose from calander with all dates, below is my date field
I wrote below load and it worked for me
Let vMinDate=Num(MakeDate(2010,1,1));
Let vMaxDate= Num(Today());
Calander:
Load
Date(($(vMinDate)+RowNo()-1),'DD/MM/YYYY') as Date,
Month($(vMinDate)+RowNo()-1) as Month,
Year($(vMinDate)+RowNo()-1) as Year
AutoGenerate $(vMaxDate)-$(vMinDate)+1;
Hi Zahmed14,
For the dates, there is a guide here that will tell you how to set the dates of ranges that you can choose. This should provide some insight for you!
Let me know if that answers your question?
Thanks,
David
hi,
if you want to select all date first click lens icon
then click ...
then click select all
all points are selected
ksrinivasan
I wrote below load and it worked for me
Let vMinDate=Num(MakeDate(2010,1,1));
Let vMaxDate= Num(Today());
Calander:
Load
Date(($(vMinDate)+RowNo()-1),'DD/MM/YYYY') as Date,
Month($(vMinDate)+RowNo()-1) as Month,
Year($(vMinDate)+RowNo()-1) as Year
AutoGenerate $(vMaxDate)-$(vMinDate)+1;