How to hide completed event from view result based on it's end date? I have created an Event Type pages which have date field Start Date-End Date, how do I hide completed event in view result or else is there any other way to unpublished them automatically?
You should Enable the "Date Views" module first. Then you will be able to find the Date CCK fields available in the filter criteria as Expected. You will also be able to provide a relative date in the filter criteria. Refer Screenshot. 

Hope this Helps!