Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I am attempting to create an intervalmatch that deals with dates. The issue I am coming across is that one of my ranges is 12/21 (dec 21) to 1/20 (Jan 20). So any data that falls into this date range results in a null. How can I indicate that following Dec comes Jan?
 
					
				
		
 datanibbler
		
			datanibbler
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
try adding information about the year to your interval - the numeric value (the sum of days from some date in the past) should then pick it up and you should be fine.
HTH
 
					
				
		
 saurabh5
		
			saurabh5
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		try creating a calender table and then use your date with year into consideration.
Regards
S
