prompt the user to choose a certain date and then use it for the local data filter [using JSL]

RA899

Hi, 

I have a date column in the mmddyyyy format. I need to print it out to the user to choose from and then use a local data filter to filter the selected dates in Graph builder. 

 

The issue I'm having is that when I try to print the data to the user, it shows it as a long integer that I can't understand. Any suggestions is appreciated. 

 

I have attached a picture of the date column from the data table. 

 

 

 	  <BR /><BR /><BR />  nw = New Window ( "    ",<<Modal,
			
			Table Box(
				String Col Box( "Select date(s)",      words (char(dateList), "," )   ), 
				
				nb = Number Col Edit Box(
					"",
					dateValuesIndex,
					dateOption = nb << get as matrix; 
				)
			),
			
			bb = Button Box( "OK", dateOption = nb << get as matrix ),//			 
			Button Box( "Cancel" )
); 

pmroz

Here's how I would do it:

dt = New Table( "datetbl", Add Rows( 6 ),
	New Column( "My Date", Numeric, "Continuous", Format( "ddMonyyyy", 12 ),
		Input Format( "ddMonyyyy" ),
		Set Values( [3786912000, 3788035200, 3788985600, 3790800000, 3792009600, 3792268800] ) )
);

date_list = dt:my date << get values;
cdate_list = {};
// Convert dates to character strings
for (i = 1, i <= nitems(date_list), i++,
	cdate_list[i] = format(date_list[i], "ddMonyyyy");
);

nw = new window("Test Dates", << modal,
	lineup = Lineup Box( N Col( 2 ),
		textbox("Select start date: "),
		date1_lb = combo box(cdate_list),
		textbox("Select end date: "),
		date2_lb = combo box(cdate_list),
	),
	ok_btn = button box("OK",
		start_date = date1_lb << get selected;
		end_date   = date2_lb << get selected;
	)
);
// Convert character dates back to real dates
start_dt = informat(start_date, "ddMonyyyy");
end_dt   = informat(end_date, "ddMonyyyy");