topic Re: Format a Number Col Edit Box in Discussions

Format a Number Col Edit Box

uday_guntupalli — Mon, 13 May 2019 17:58:13 GMT

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 
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 );

Re: Format a Number Col Edit Box

Mark_Bailey — Mon, 13 May 2019 18:49:50 GMT

Right, the protocol for the Number Edit Box and the Number Col Edit Box are not the same. In particular, the << Set Format() message is different for these two objects. Per the Scripting Guide, this message uses a number (code) for the format specification of the object that you want to use:

Re: Format a Number Col Edit Box

Mark_Bailey — Mon, 13 May 2019 18:57:21 GMT

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.

Re: Format a Number Col Edit Box

uday_guntupalli — Mon, 13 May 2019 19:18:32 GMT

@Mark_Bailey,

Thank you . While that works, it is not intuitive that a number will implement some kind of formatting on the number col edit box, rather than the more intuitive format that the number edit box allows. I will be adding this to the wish list.

Re: Format a Number Col Edit Box

Mark_Bailey — Mon, 13 May 2019 19:26:03 GMT

This method of specifying the format is the original way. It is the way that we used to set the format for the Number Col Box object. I was surprised to see that the newer Number Col Edit Box object still used it.