770809_en-US

liliconcom

Get month name so i can display it

I'd like to retrieve the current month's name to display it in my results.

I tried using this function but i get every time the current date in format dd/mm/yyyy  :

current_month = Format(Today(), "Mon");

textbox_result << Set Text(
        "ICT  NOK  %  for " || current_month || " is " || Char(Round(percent_nok_ict, 2)) || "%\!N" ||
        "FCT  NOK  %  for " || current_month || " is " || Char(Round(percent_nok_fct, 2)) || "%"
    );

 

 

Automation and ScriptingContent OrganizationSharing and Communicating ResultsWindowsRe: Get month name so i can display it

You could use Format Pattern

 

Names Default To Here(1);

opt1 = Format(Today(), "Format Pattern", "<MONTH>");
opt2 = Format(Today(), "Format Pattern", "<MMM>");

show(opt1, opt2);</MMM></MONTH>

Re: Get month name so i can display it

That works perfectly, thank you !
I have a quick follow-up question. I successfully retrieved the month, but it's currently in French. Is there a function in JMP that can translate it to English ?

Re: Get month name so i can display it

I'm not sure if << Use Locale(0) would work

Names Default To Here(1);

opt1 = Format(Today(), "Format Pattern", "<MONTH>", << Use Locale(0));</MONTH>

If not you could create conversion list and use that

Names Default To Here(1);

months = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"};

months[Month(Today())];

Re: Get month name so i can display it

If you use the English version of JMP, a very nasty workaround:

"use JMP language ..."

from the Preferences/Windows Settings.

It will interfere with dozens of other functions (csv import, date in data tables ....)

Re: Get month name so i can display it

Thank you! Using Locale(0) worked perfectly.