Date: Date Type, Modeling Type and Format -> How to fix MMM/YYYY

BSwid

Data in format MMM/YYYY (001/2019, 002/2019, ...012/2019) is being imported as Date Type Character, Modeling Type Nominal.
I'm trying to get JMP to recognize this as a date.  The final format isn't import per se.  I show a format below just as an example. 

I've tried scripting two ways to fix with no luck. The column name is "MMM/YYYY"

 

[fail #1]

names default to here(1);
dt = current data table();
dt<< column(:"MMM/YYYY",Numeric,Continous,Format( "m/d/y", 10));

 

[fail #2]

names default to here(1);
dt = current data table();
:"MMM/YYYY"() << Date Type(Numeric) << Modeling Type(Continous) <<Format( "m/d/y", 10);

 

 

gzmorgan0

The script below demonstrates that a simple Informat() will work, or you can strip off the leading zero and use Informat() .

New Column( "Date",
	Numeric,
	"Continuous",
	Format( "m/y", 12 ),
	Formula( Informat( Right( :Name("MMM/YYYY"), 8 ), "m/y" ) )
);

New Column( "Date2",
	Numeric,
	"Continuous",
	Format( "m/y", 12 ),
	Formula( Informat(  :Name("MMM/YYYY") , "m/y" ) )
);