i have 2 date columns, startdate and enddate.
i need to filter out the enddate by the min of the startdate.

for example, if i have min start date of 1.1.2014 i cant have enddate of 1.1.2013.

you have an idea how can i do it? 
filter rows, by columns max values
hi @kuyu,
got it. in this case the extract macro operator is very helpful, as it can give you statistics about an specific attribute. in this case the only extra step is that dates are extracted in milliseconds since epoch (the most common way computer handle internally date and time values), so we need to transform the date\_end column as well for comparison.
best,david


  
    
    
    
  
  
    
    
    
    
    
    
    
      
        
        
        
        

          
          
        

        
        

          
          
        

        

        

        
        
        
        
        
        
      
      
        
        
        
        
        

      
      
        
        
        
        

        
        
        the min\_date macro is extracted as milliseconds since epoch, so we transform the date\_end as well to this format
      
      
        
        
        
        

        
        
      
      
      
      
      
      
      
      minimum start\_date is december 1st
    
  
