Format a Number Col Edit Box

uday_guntupalli

All, 
     I would like to use a number col edit box similar to a number edit box in that, I would like to format it to display a date. However, as shown in the following example the format doesn't seem to be accepted the same way ? Can someone point out whats wrong in the following approach ? 

 

// Using Number Col Edit Box <BR />nR = 7; 
NEB1 = Number Col Edit Box("StartDate",Repeat(Today() - 30 * 24 * 60 * 60,nR)); 
NEB1 << set format(format("ddMonyyyy"));

NEB2 = Number Col Edit Box("StartDate",Repeat(Today(), nR ));
NEB2 << set format(format("ddMonyyyy"));

TB1 = Table Box(NEB1,NEB2);
			   
NW = New Window("test",TB1); 


// Using number edit box 
numbox = Number Edit Box( 0 ,<< set format(format("ddMonyyyy")), << set(Today()));
 
NW1 = New Window( "Example", numbox );

 

Mark_Bailey

Here is an example of how this message works:

 

Names Default to Here( 1 );

now = Today();

then = now - In Days( 3 ) - In Hours( 5 );

before = then - In Days( 2 ) + In Hours( 3 );

New Window( "Format Number Col Edit Box",
	Outline Box( "Dates",
		Table Box(
			String Col Box( "Event", { "First", "Second", "Third" } ),
			nceb = Number Col Edit Box( "Date", { now, then, before } )
		)
	)
);

nceb << Set Format( 30, 100 );

 

I don't know what kind of date format you want, so you might have to try different integers to get the one that you want.