Select Where on Dates

KST-CPT

I am trying to create a subset of a data set.  I want to select the dates outside of my start and end dates for analysis, then exclude such dates.  Not sure why this is not working, seems easy.  I think it is number format issues?

I have StartDate and EndDate as dates from CalendarBox()

:Date is a column with numeric dates in format m/d/y.

 

I have tried this to no success:

 

BegTime = dt<< Subset(All rows, Selected columns only( 0 ) );
BegTime << Select Where(:Date < Informat(StartDate) |:Date > Informat(EndDate))<<Exclude;));

 

To check the columns I tried this (below) but did not get a result.  Just ".

 

BegTime <<new column("blah", numeric, formula(
num(:Date) - num(StartDate);

 

txnelson

I think your issue is that you are thinking that StartDate and EndDate are numeric dates.  The way you have constructed your code, StartDate and EndDate are pointers to objects.  You need to extract the date values from the objects and place them into variables of your choosing.  Also, your use a Modal window will not let any processing run, such as the setting of the range of the choices for the dates to choose from.  So I have also removed that restriction.  So if you follow the logic of the script below, you will see how to handle the processing control without using Modal windows.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Time Series\Raleigh Temps.jmp" );
dt << clear row states;
startNW = New Window( "Start Date of Data",
	StartDate = Calendar Box(),
	Button Box( "OK",
		startNW << close window;
		runEndDate;
	)
	
);
StartDate << Max Date( Col Max( :name( "Month/Year" ) ) ) << Min Date( Col Min( :Name( "Month/Year" ) ) );


StartDate << Set Function( Function( {this, date}, theStartDate = StartDate << Get Date ) );

runEndDate = Expr(
	endNW = New Window( "End Date of Data",
		EndDate = Calendar Box(),
		Button Box( "OK",
			endNW << close window;
			runSelect;
		)
	);
	endDate << Max Date( Col Max( :name( "Month/Year" ) ) ) << Min Date( Col Min( :Name( "Month/Year" ) ) );
	EndDate << Set Function( Function( {this, date}, theEndDate = endDate << Get Date ) );
);

runSelect = Expr(
	dt << select where( :Name( "Month/Year" ) < theStartDate | :Name( "Month/Year" ) > theEndDate )
);