Ordinal Date String Columns

Question

So I have a Numeric Continuous DATETIME column in this format: 2017/04/22 10:56:37 PM

And what I'd like to do is get this format: Mon yy  (as in Jun 18)

I just need it ordered and for some reason nothing I'm trying is working. Formatting with Jun is for some reason causing it to become a character that is not ordinal so please help! I just want to make sure that if I plot these dates, they're in order.

txnelson · Answer

I apparently was not clear in what I was passing on to you.  What the code I gave you above, is a custome format.  Not a Value Ordering specification.  What you need to do, is to copy exactly the code I gave you, and paste it into a Custom Format

Select "Set Custom Format"

And it will produce the following output.  The below data table has the "date" in the format you want, and the actual date in the column called "Full Date".  The table was sorted in asscending order based on the "Date" column.

agonzales2021 · Answer

Final_tab:Month << Set Property("Value Ordering",

molist = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"};
molist[Month( :TKOUT_TIME )] || " " || Char( Month( :TKOUT_TIME ) );
);

? I still get it coming out of order

txnelson · Answer

Oops,

Given that, you can define a custom format to do what you want.  The format to use is:

molist = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"};
molist[Month( :value )] || " " || Char( Month( :value ) );

Assuming you are using JMP 13