topic Help required in setting Conditions in From Date and To Date in QlikView https://community.qlik.com/t5/QlikView/Help-required-in-setting-Conditions-in-From-Date-and-To-Date/m-p/397632#M148105 <HTML><HEAD></HEAD><BODY><P>Hi Miguel, I am using the below script to create from Date and To Date MaxMinDate: Load max(Date) as MaxOccurredDate, min(Date) as MinOccurredDate resident Incident; Let vMaxOrderDate = floor(peek('MaxOccurredDate',-1,'MaxMinDate')); Let vMinOrderDate = floor(peek('MinOccurredDate',-1,'MaxMinDate')); Drop table MaxMinDate; Calendar: Load *, Day(Start_Date) as SDay, Month(Start_Date) as [SMonth], Year(Start_Date) as [SYear] ; Load date(floor(recno()+$(vMinOrderDate)-1)) as Start_Date Autogenerate(vMaxOrderDate-vMinOrderDate+1); Calendar2: Load *, Day(End_Date) as EDay, Month(End_Date) as [EMonth], Year(End_Date) as [EYear] ; Load date(floor(recno()+$(vMinOrderDate)-1)+1) as End_Date Autogenerate(vMaxOrderDate-vMinOrderDate+1); I am using 2 calender Objects in Front End Requirement Calender 1 Object Default date to be set to 6th Jul 2009 and when i select To Date the calender should show me dates greater than From Date in Calender view Ex if i select 7th July 2009 in From Date calender then in my To Date calender when i click on calender it should show me dates gretaer than 7th July 2009 1to ^th Should be grayed out. Is it possible. I am struggling with it Any Help will be much appreciated. If the user selects To Date Less than From Date a pop msg should display telling user to enter the to date greater than From Date. Regards Raj</P></BODY></HTML> Wed, 27 Mar 2013 08:22:00 GMT rajtechnocraft 2013-03-27T08:22:00Z Help required in setting Conditions in From Date and To Date https://community.qlik.com/t5/QlikView/Help-required-in-setting-Conditions-in-From-Date-and-To-Date/m-p/397632#M148105 <HTML><HEAD></HEAD><BODY><P>Hi Miguel, I am using the below script to create from Date and To Date MaxMinDate: Load max(Date) as MaxOccurredDate, min(Date) as MinOccurredDate resident Incident; Let vMaxOrderDate = floor(peek('MaxOccurredDate',-1,'MaxMinDate')); Let vMinOrderDate = floor(peek('MinOccurredDate',-1,'MaxMinDate')); Drop table MaxMinDate; Calendar: Load *, Day(Start_Date) as SDay, Month(Start_Date) as [SMonth], Year(Start_Date) as [SYear] ; Load date(floor(recno()+$(vMinOrderDate)-1)) as Start_Date Autogenerate(vMaxOrderDate-vMinOrderDate+1); Calendar2: Load *, Day(End_Date) as EDay, Month(End_Date) as [EMonth], Year(End_Date) as [EYear] ; Load date(floor(recno()+$(vMinOrderDate)-1)+1) as End_Date Autogenerate(vMaxOrderDate-vMinOrderDate+1); I am using 2 calender Objects in Front End Requirement Calender 1 Object Default date to be set to 6th Jul 2009 and when i select To Date the calender should show me dates greater than From Date in Calender view Ex if i select 7th July 2009 in From Date calender then in my To Date calender when i click on calender it should show me dates gretaer than 7th July 2009 1to ^th Should be grayed out. Is it possible. I am struggling with it Any Help will be much appreciated. If the user selects To Date Less than From Date a pop msg should display telling user to enter the to date greater than From Date. Regards Raj</P></BODY></HTML> Wed, 27 Mar 2013 08:22:00 GMT https://community.qlik.com/t5/QlikView/Help-required-in-setting-Conditions-in-From-Date-and-To-Date/m-p/397632#M148105 rajtechnocraft 2013-03-27T08:22:00Z